Select dynamic string has a different value when referenced in Where clause
- by David
I dynamically select a string built using another string. So, if string1='David Banner', then MyDynamicString should be 'DBanne'
Select
...
, Left(
left((select top 1 strval from dbo.SPLIT(string1,' ')) //first word
,1) //first character
+ (select top 1 strval from dbo.SPLIT(string1,' ')
//second word
where strval…