Change the above query as per need.
Find a String in a String in SQL Server
Learn how you can find data in a string and extract it, no matter where it's located.
2016-03-10
32,519 reads
SterlingHall1,
2014-10-07 (first published: 2014-09-05)
Change the above query as per need.
--Find only characters from string : DECLARE @Temp VARCHAR(100)='548STA123Ldfgh45df45df5446fg54645dfg546'; Declare @NumRange AS varchar(50) = '%[0-9]%'; While PatIndex(@NumRange, @Temp) > 0 SET @Temp = Stuff(@Temp, PatIndex(@NumRange, @Temp), 1 ,'') SELECT @Temp --==================================== Find only integers from string : DECLARE @var VARCHAR(100)='5STA123Ldfgh45df45df5446fg54645dfg546'; DECLARE @intdata INT SET @intdata = PATINDEX('%[^0-9]%', @var) BEGIN WHILE @intdata > 0 BEGIN SET @var = STUFF(@var, @intdata, 1, '' ) SET @intdata = PATINDEX('%[^0-9]%', @var ) END END Select ISNULL(@var,0) --Find a float value from string : DECLARE @var VARCHAR(100)='STA123.26dfg'; DECLARE @intdata INT SET @intdata = PATINDEX('%[^0-9]%', @var) BEGIN WHILE @intdata > 0 BEGIN SET @var = STUFF(@var, @intdata, 1, '' ) SET @intdata = PATINDEX('%[^0-9.]%', @var ) END END Select ISNULL(@var,0)
Learn how you can find data in a string and extract it, no matter where it's located.
There are certain circumstances where SQL Server will silently truncate data, without providing an error or warning, before it is inserted into a table. In this tip we cover some examples of when this occurs.
2013-02-01
4,303 reads
This article will show some common integer data-type conversions using T-SQL.
Fill in another bit of your T-SQL knowledge about STR(). It right justifies, rounds, and controls the output width of columns. Sounds perfect but here's why you might not want to use it.
2019-04-26 (first published: 2010-12-15)
15,581 reads
Often in database design we store different values in rows to take advantage of a normalized design. However many times we need to combine multiple rows of data into one row for a report of some sort. New author Carl P. Anderson brings us some interesting T-SQL code to accomplish this.
2011-03-04 (first published: 2009-10-14)
149,479 reads