Showing results for 
Search instead for 
Do you mean 

Apostrophes can Cause Problems in SQL Server Queries.

by Anonymous on ‎02-24-2016 09:15 AM - edited on ‎04-06-2016 09:07 AM by Moderator (459 Views)

Apostrophes in MS SQL attribute fields can cause problems even for MS SQL database users. If GeoMedia is used to create the attribute query so that the apostrophe has another single quote then it will work.

 

 Here are some examples:

 

  • Name = 'St. Patrick''s'
  • Name LIKE 'St. Pat%' or even Name LIKE 'St. Patrick%s'
  • Some MS SQL database admins replace the apostrophe in the database.
Contributors