Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
peace
Constraint Violating Yak Guru
420 Posts |
 Posted - 2014-06-30 : 00:50:57
|
| select .... from tableB BLEFT JOIN tableA A ON A.Id = B.Id AND ((UPPER(A.FirstName) + ' ' + UPPER(A.LastName) = UPPER(@Name)) OR (UPPER(A.LastName) + ' ' + UPPER(A.FirstName) = UPPER(@Name)))I dont really understand the UPPER in left join..anyone can help?Thanks |
|
|
mmkrishna1919
Yak Posting Veteran
95 Posts |
Posted - 2014-06-30 : 04:44:37
|
| it is Case insensitive, i think there is no significance to UPPER clause in above join conditions.M.MURALI kRISHNA |
 |
|
|
|
|
|
UPPER