I have a stored procedure to search a string but, it fails when it has white spaces at the beginning of it.
Example: 'abc' searches perfectly but, ' abc' fails. Cannot use like in the query.
The query I have is
SET @SQL = @SQL + ' AND Auth = ''' + CAST(@Auth AS NVARCHAR(50))+ ''''