sql problem

[charvi]

i have a syntax problem in access
i have a table with fields name and code
for eg name-dana int'l & code=dl
now i want to fetch this data in other form
when i use select query it gives error saying operatop missing
that is if i write dana intl it will execute
instead if i write dana int'l i will get error
pls help me

[hariharanmca]

i have a syntax problem in access
i have a table with fields name and code
for eg name-dana int'l & code=dl
now i want to fetch this data in other form
when i use select query it gives error saying operatop missing
that is if i write dana intl it will execute
instead if i write dana int'l i will get error
pls help me

you have to search like

strSql="select <Fields> from <Table Name> where <SearchField> Like "
strSql=strSql & " 'dana int''l' "

'dana int''l -> <single quot>dana int<single quot><single quot>l<single quot>

[Killer42]

For more info, refer to the following links...
List of articles and code snippets in Access forum
Quotes and Double-Quotes - Where and When to use them
VB example - how to search on string containing an apostrophe