Select records where there are spaces in the text

[jcfrasco]

Hello,

I am trying to write a select statement that will show me how many records in a table have spaces in the middle of the text. The field is for entering the last name of users but the customer has used it for entering other data that was relevent to them and not the data is corrupted. I have used the wildcard brackets to search for special characters and that works perfectly, but now I must also find which records have spaces (not leading or trailing) so I can exclude those when I transfer good records to a new table.

Thank you for any assistance with this problem.

jcfrasco

 

[gmmastros]

[tt][blue]
Select *
From Table
Where RTrim(LTrim(ColumnName)) Like '% %'
[/blue][/tt]

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[jcfrasco]

George,

Thank you for your quick reply and I feel a little foolish to not have figured that out. I was looking for the more complicated solution and didn't even think of trying that.

Very much appreciated!

jcfrasco

 

[gmmastros]

You're welcome.

Life should only be as complicated as it has to be.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom