Return only letters in nvarchar.

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 2005 Forums

Transact-SQL (2005)

Return only letters in nvarchar.

Author

Topic

Gili
Starting Member

42 Posts

Posted - 2009-05-18 : 07:27:22

Hi,

Is there any function in t-sql that receive nvarchar and return only letter?
for example '545test85@@' it will return 'test'.

Thanks.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-05-18 : 09:08:19

Use [a-z] in place of [0-9]
http://sqlblogcasts.com/blogs/madhivanan/archive/2007/12/18/extract-only-numbers-from-a-string.aspx

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources