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
 General SQL Server Forums
 New to SQL Server Programming
 Need Help in a selecting statement

Author  Topic 

rjnealtx
Starting Member

1 Post

Posted - 2006-05-18 : 10:37:45
I have a column within a table with date like 25C1, 26B1, 345SS4, 432BRP5, ect........

I need the remove the numbers both front & back and leave only the letters.

Like C, B, SS, BRP...........

The letters will be in a new column.....

Thanks

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-05-18 : 10:39:59
Refer this
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56713

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -