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 |
|
PeterG
Posting Yak Master
156 Posts |
 Posted - 2003-05-22 : 18:47:28
|
| On my web page I have alphabet links and an "Others" link. When you click any of the alphabet links, a query to search by that alphabet is done - syntax: select ... where Fieldname like 'A%'. Now what about the syntax for the "Others" link? It should be a search for records that start with characters other than an alphabet. It could be numeric, a comma, etc. (maybe exclude the SQL server reserved characters). |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-05-22 : 18:52:35
|
| you can dowhere field like '[^a-zA-Z]%'==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
PeterG
Posting Yak Master
156 Posts |
Posted - 2003-05-22 : 18:56:34
|
| I knew this one from regular expression, but I didn't think I couldn't use reg exp in sql.Anyways, thanks nr. |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-05-23 : 09:10:58
|
| It's good to know that there is a regular expression DLL for SQL. Has anyone at SQLTEAM had experience using it?Sam |
|
|
|
|
|
|
like syntax