I am trying to set this col but I get an error:
FirstName + (CASE WHEN LEN(FirstName + LastName) > 0 THEN ' ' ELSE '') + LastName
views:
69answers:
2
+1
A:
FirstName + (CASE WHEN LEN(FirstName + LastName) > 0 THEN ' ' ELSE '' end) + LastName
missing the end
cmsjr
2009-08-02 19:54:17
But what if last name length was 0 ?
Wahid Bitar
2010-01-23 15:27:17
I was just addressing the OP's syntax problem, not his approach.
cmsjr
2010-01-24 01:17:50
+2
A:
You should close CASE with END and also, to my opinion, the following value will be better:
FirstName + (CASE WHEN LEN(FirstName) > 0 AND LEN(LastName) > 0 THEN ' ' ELSE '' END) + LastName
Sergey Olontsev
2009-08-02 19:55:21
Good point about counting the chars and sum them vs. concatenating strings which cost more performance.
Shimmy
2009-08-02 22:59:26