RIAS
asked on
SQL Query
Hello,
How can I modify this query to have filter like' starts with '
Regards
How can I modify this query to have filter like' starts with '
IF @PatientName <> ''
SET @SQL = @SQL + ' AND PatientName LIKE ''%' + CAST(@PatientName AS Nvarchar(MAX)) + '%'''
Regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.Worked brilliantly.
ASKER