KCL Software Solutions

SQL for locating Smart Quote, Em-Dash, Elipsis

Special characters commonly inserted when pasting from formatted documents like Microsoft Word can cause data portability and indexing problems. The following searches help identify most cases of records with a Smart Quote, Em-Dash, or Ellipsis.

Community Information:
btd.SRCH_Anywhere LIKE '%’%'
OR btd.SRCH_Anywhere LIKE '%‘%'
OR btd.SRCH_Anywhere LIKE '%”%'
OR btd.SRCH_Anywhere LIKE '%“%'
OR btd.SRCH_Anywhere LIKE '%–%'
OR btd.SRCH_Anywhere LIKE '%…%'

Volunteer:

vod.SRCH_Anywhere LIKE '%’%'
OR vod.SRCH_Anywhere LIKE '%‘%'
OR vod.SRCH_Anywhere LIKE '%”%'
OR vod.SRCH_Anywhere LIKE '%“%'
OR vod.SRCH_Anywhere LIKE '%–%'
OR vod.SRCH_Anywhere LIKE '%…%'

Once you located these records, you can use the Find Operation in your browser to identify the location of the problem character by doing a find for each of the characters between the % signs above.

Did you find this article helpful?