Loading

How to select a single data inside of a column?

Reden Rodriguez

7y835SQL

i dont know if my question is correct sorry for wrong English grammar but my sample question is this, i have a column named address inside of this column is like this qqq/aaa/bbb and i only want to select bbb inside of the column address and select it along with other columns.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nirav Gandhi7y ago
Hi Reden,

Please use the below sample query to filter your data, replace your table in below query
Declare @Table as table
(
Address varchar(500)
)
insert into @Table
select 'qqq/aaa/bbb'

select * from @Table
Cross apply(select value from STRING_SPLIT('qqq/aaa/bbb','/')
where value ='bbb'
) as TT
SQL Server 2016 have direct STRING_SPLIT Function.
0
Gajendra Jangid7y ago
hii renden

use following query :
DECLARE @FilePath VARCHAR(50) = 'My\Super\Long\String\With\Long\Words'
DECLARE @FindChar VARCHAR(1) = '\'

SELECT RIGHT(@FilePath, CHARINDEX(@FindChar,REVERSE(@FilePath))-1) AS After
+1