Sign in | Join | Help

Madhivanan

This Blog

  • Home
  • Contact

Syndication

  • RSS
  • Atom
  • Comments RSS

Search

  • Go

Tags

  • alias name
  • Audits
  • backup
  • bcp
  • behaviour changes
  • coalesce
  • column length
  • count
  • Count words
  • Crosstab
  • csv
  • daily backup
  • data length
  • date
  • datetime
  • delete duplicate
  • dynamic crosstab
  • excel
  • export data
  • Export to Excel
  • export to Text
  • Extract numbers
  • free tool
  • functions
  • Generate sql script
  • image
  • Implicit conversion
  • import excel
  • IP address
  • ISDATE()
  • isnull
  • isnumeric
  • multiply
  • newid()
  • normalise
  • Nth Maximum
  • number
  • openrowset
  • pagination
  • parsename
  • PIVOT
  • procedure
  • procedures
  • random
  • random numbers
  • random password
  • Remove duplicates
  • row count
  • Row number
  • script
  • single quotes
  • split
  • sql server
  • sql to excel
  • sqlanswer
  • squeeze
  • store images
  • Stuff
  • table structure
  • tally number table
  • tempdb
  • time
  • Top columns
  • Truncate
  • T-sql
  • undocumented
  • union vs union all
  • WRITE

Navigation

  • Home
  • Blogs
  • Forums
  • Photos
  • Downloads

Archives

  • June 2008 (1)
  • May 2008 (2)
  • April 2008 (2)
  • March 2008 (1)
  • February 2008 (2)
  • January 2008 (2)
  • December 2007 (6)
  • November 2007 (7)
  • October 2007 (4)
  • September 2007 (1)
  • August 2007 (17)

Browse by Tags

All Tags » Extract numbers (RSS)
  • sql server
  • T-sql
18 December 2007 14:48

Extract only numbers from a String

Sometimes we may need to extract only numbers from a string. Usually I see people using while loop to check each and every character to see if it is a number and extract it Here is a different approach Declare @s varchar ( 100 ), @result varchar ( 100...
Posted by Madhivanan | 4 comment(s)
Filed under: sql server, Extract numbers, T-sql
Powered by Community Server (Commercial Edition), by Telligent Systems