I'm trying to extract first name from full name using Substring(@fullName,1,Charindex(" ",@fullName))
However, it does not work. My Charindex returns 0. Can someone help me with this?
Thanks in advance!
Thanks so much Anita.
I'm trying to substring only when there's a space. However, I got a case function error for the expression below. Can you help?
Case(When(@fullName LIKE ' ', Substring(@fullName,0,Charindex(@fullName, " ")), Else(@fullName)))
The index of Substring starts with "0".
Try below expression. This should work.