Display name fixed number of character remaining fill with specific character

     In the following example, I want to fill the name exactly 20 characters, if the character count is exceed 20 character remove remaining character and if the character is lesser than 20 character fill with blank space(left aligned).

Example
  SELECT convert(nvarchar(20),LEFT(CONVERT(NVARCHAR, 'Merbin Joe') + SPACE(20), 20)) Name

This will produce
 Merbin Joe
Left align with fixed number of characters





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

quoutename in sql






Nhận xét

Đăng nhận xét

Bài đăng phổ biến từ blog này

How to find motherboard model, version and serial number?

Hình ảnh
     If you bought a new or second handed  motherboard, it may not have a proper driver software. It will be very difficult to find the suitable driver software. This post will be helpful to find the suitable driver software like sound driver, video driver, chip set driver and all motherboard related softwares.      In your computer just open the comment prompt(Window key + R => cmd=> enter) and type the following command.      wmic baseboard get product,Manufacturer,version,serialnumber Step 1: Click on Start => Run Step 2: Type cmd and press OK. Step 3: Right click and paste this commands " wmic baseboard get product,Manufacturer,version,serialnumber " then press Enter. Note: ctrl  + v shortcut does not work here. Now you can search using the model number ( here  DH61WW ) in internet.
Đọc thêm