Like statement?

[Schaeffrcc]

I have a Query that pulls a subset of data into a temp table and then has to look for field that contain a Char. it looks like below:

UPDATE clients SET clients.client_city = Null
WHERE (((clients.client_city)=" "));

Now I also want this statement or another one to update the field to Null if it contains the " " anywhere in the field I.E. Minn eapolis should be updated to Null.

can anyone help,

Thomas

 

[amorous]

Does this help:

UPDATE clients SET clients.client_city = Null
WHERE (((clients.client_city) LIKE '% %'));

-VJ

 

[TJRTech]

I know the original poster asked for a LIKE solution, but you might want to see if CHARINDEX performs faster than a like with two % signs:

UPDATE clients 
SET clients.client_city = NULL
WHERE CHARINDEX(' ', clients.client_city)>0
[CODE]

Of course, if not updating 10s of 1000s of recs it probably doesn't matter.

TR