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 |
|
DEMM
Starting Member
2 Posts |
 Posted - 2007-06-06 : 19:14:17
|
| hi!i have one table with a field called name witch has names like:SarahSimao SabrosaQuimLuis FigoZinedine Zidane111111Jose Antonio ReyesRuud Van Nistelrooy...and i want to make a Query that lists all the "incorrect" names, like names with only one word...i tried this:.......WHERE name not like '?*?*?*'the ?s means the spaces between the names and * means any name...this was suppous to give me the names with at least two words, but this '?*?*?*' is attributed like *, so the result is an empty table...can you Help me ? |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-06 : 19:25:53
|
| What is the DB you are working on?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
DEMM
Starting Member
2 Posts |
Posted - 2007-06-06 : 19:40:41
|
| i'm using ms access 2003 |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-06 : 19:42:39
|
| hmm..you are prbly knocking the wrong door. This is a SQL Server forum. there's probably an Access forum where you have a better chance of getting a solution.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
SQL query