You can take this as an example:
DECLARE @Delimitedtext varchar(max);
DECLARE @Delimiter char(1);
SET @Delimitedtext = 'Manas Bhardwaj';
SET @Delimiter = ' ';
DECLARE @FName nvarchar(max)
DECLARE @LName nvarchar(max)
SELECT
@FName = SUBSTRING(@Delimitedtext,1, CHARINDEX(@Delimiter, @Delimitedtext)-1),
@LName = SUBSTRING(@Delimitedtext,CHARINDEX(@Delimiter, @Delimitedtext)+1, len(@Delimitedtext))
Select
[name]
from
names
where
[name] like '%' + @FName + '%'
or
[name] like '%' + @LName + '%'
I have assumed here that the name will always be comprised of FirstName and LastName. :rose:
Manas Bhardwaj Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
