Query to find & replace wildcards??*** 1

[tina2]

I have an access DB that is going to be converted to SQL Server. Before we convert, there are several things that need to be cleaned up. Unfortunately, some of them are asterisks and question marks, which are impossible to find & replace. I started with the below query, but it just brought up all of the records that contained data.

SELECT [Client Addresses].Address1
FROM [Client Addresses]
WHERE ((([Client Addresses].Address1) Like "*"));

Any suggestions would be appreciated!

Kristine

 

[PHV]

Have you tried this ?
Like '*[*]*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[tina2]

That was the ticket!
Thanks for your speedy reply PH!