Example( jhon, bosco) in contact’s table , jhon is first and bosco is last name, how to find all contacts starts with a letter(eg:- b) in their last name,
Note. Fists name and last name in a single colum separated by comma
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Answer by swarnava2014 · Jun 26, 2020 at 05:06 PM
select * from [table_name] where SUBSTRING([column_name],CHARINDEX(',',[column_name],0)+2,1)='b'
Answers Answers and Comments
19 People are following this question.
Comma delimited File Load using SQL 2005
Dynamic sql query to convert single column string delimited with semicolon (;) to multiple columns
SQL Server 2008 on 64bit Windows Server
SUM OF COUNTS?
Allocation of RAM and space for the sql server