SQL to Append all Fields if Shorter than a set Length
This came in very handy for me at one point because I needed to have a certain field in each row 14 characters long, but half of them were only 12 characters long.
In MySQL:
|
|
In MSSQL:
|
|
This came in very handy for me at one point because I needed to have a certain field in each row 14 characters long, but half of them were only 12 characters long.
In MySQL:
|
|
In MSSQL:
|
|