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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 HOW TO CHK ALPHABATES(LETTERS ONLY)

Author  Topic 

AsimKhaliq
Yak Posting Veteran

94 Posts

Posted - 2004-03-15 : 16:34:14
HI

I WANT TO CHK THAT MY FIELD CONTAINS ONLY ALPHABATES LETTERS ONLY
CAN SOMEONE HELP ME

EX SELECT NAME FROM TABLE1 WHERE NAME=????????

NOTE=I PUT ???? SO CAN CA WRITE ME A FUNCTION THERE
THNX

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2004-03-15 : 22:59:28
There was a similar problem dealt with at this forum Yesterday (Probably same day depending which country you are in). Here someone just wanted to extract the numerics from a field, you could possibly modify this function accordingly to achieve what you are looking for.

Have a look.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=33387


Duane.
Go to Top of Page
   

- Advertisement -