HELP WITH SQL LIKE QUERY

[dmoonme]

TableA fields are unc_path and office.

My update query looks like this:

update TableA set office='CRB' where unc_path like '%crb%'

The query doesn't seem to work even though there are records that match this criteria. An example of a record in the unc_path is \\crbA1\MyDir\akde12

Thanks in advance for your help!

 

[r937]

try using asterisks instead of percent signs

rudy

http://r937.com/

SQL Consulting

 

[dmoonme]

THANKS! That did the trick!

 

[citychap26]

Hi

Just wanted to add the "%" is what you would use for SQL Server, ORACLE or Sybase. However MS Access like "*".

So note if you are using a passthrough query or ADO then use "%"

Cheers

SK