select first 10 numeric values

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)

select first 10 numeric values

Author

Topic

oracle_corrgi
Yak Posting Veteran

98 Posts

Posted - 2006-08-11 : 02:13:12

hi
ps let me know how to select only the first 10 numeric values from this data

dgdgdg12121ff4545445488gg
eg:121214545445

its very urgent
pls

thanxs

database

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-08-11 : 02:49:13

make use the function here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=33433&SearchTerms=fn_extract_chars

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-08-11 : 12:40:23

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56713

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources