AnsweredAssumed Answered

How to search for em dash using query.

Question asked by JayaSantoshKumar on Feb 13, 2018
Latest reply on Feb 14, 2018 by urmas

Hi ,

 

While copy pasting, some of the Resource OBS units were created having Em Dash.

 

So we need to identify such Resource OBS units having Em Dash( double hyphen) with query, but not able to know how to use it in the query.

 

Using the below query I can get the Resource OBS units , but dont know how to match the Unit name.

 

select * from (
SELECT
POU.UNIQUE_NAME UNIT_ID
,Pou.Id id
,POU.NAME
,pou.type_id type_id
FROM
Prj_Obs_Units POU
where pou.type_id in (select id from PRJ_OBS_TYPES where unique_name='resource')
)A

-- where A.name like '%<Condition>%'

 

How to frame the <condition>  so that I can search with double dash ?

 

I have tried '%--%' , but doesn't give me result.

 

Thanks.

Outcomes