LIKE query

[kwalt]

i have a database of businesses with their names and addresses.

i am trying to pull all the businesses that end in 's, for example: charlie's pizza, jim's auto, jane's towing ect....

im using this code

select business_name
from obd
like '%'S'
;

i receive and error. what code should i use to only select business names that end in 's

Thanks

[TheShabz]

SELECT business_name
FROM obd
WHERE business_name Like "*'s*";

what that does is look for the string "'s" anywhere in the business_name and pulls it. you mentioned you wanted all businesses that end in 's but thats not really what you want as none of the examples you gave actually end in 's. You're looking for 's to be part of the name.

[ConneXionLost]

Try this:

SELECT business_name
FROM obd
WHERE business_name Like "*'s*";

Cheers,

[TheShabz]

connexion, fixed my post right as you mentioned it, thanks for the backup =]