Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-08 : 22:05:13
|
Paul writes "My question is...
How can I select a field in a table that has one or many invalid characters. I'm looking for any of these characters (!,*,&,$,^,%,#,?,\ or @) in an customer code field. Most records don't have any and some might only have 1 or all of the characters in any order. This question might sound like bs but I really do need this so any help you may be able to offer would be greatly appreciated.
PS - If I didn't describe it well enough above this is kind of what I'm looking for.
SELECT CustomerCode FROM Customers WHERE (!,*,&,$,^,%,#,?,\ or @) IN CustomerCode." |
|
|
|
|
|
|
|
Selecting a field that may contain 1 or many invalid characters.