Example
SELECT convert(nvarchar(20),LEFT(CONVERT(NVARCHAR, 'Merbin Joe') + SPACE(20), 20)) Name
This will produce
Merbin Joe
But you can't able to see the blank space's so you should need to identify the space using [] or other way.
SELECT quotename(convert(nvarchar(20),LEFT(CONVERT(NVARCHAR, 'Merbin Joe') + SPACE(20), 20))) Name
0 nhận xét:
Đăng nhận xét