View Single Post
  #2 (permalink)  
Old 2006-12-12, 12:06 AM
drgovind06 drgovind06 is offline
Junior Member
 
Join Date: Dec 2006
Posts: 5
drgovind06 is on a distinguished road
Default

Hello Friend,
The Like clause needs ' (quotes ) around it to work

for e.g.

Select * from table2 where x like 'abcd%'

the code suggested earlier seems to generate

Select * from table2 where x like abcd%

Quotes missed out so .... its likely to generate some error.


regard
RG
Reply With Quote