right justified values

• anakin

  SSC Veteran

  Points: 272

  More actions

  April 17, 2003 at 9:37 am

  #81595

  Hi,

  my query is: SELECT code FROM table

  code is varchar(16).

  if code is shorter than 16 I want put in front some zeros so my code is right justified.

  Example:

  0000000000000001

  0000000000009971

  0dbdbdbdbdbdbdb1

  8878887878787871

  It's possible write a query to return right formatted values ?

  Thanks, anakin

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  April 17, 2003 at 9:58 am

  #454579

  You can find a couple of examples on how to pad with zeros here:

  http://www.geocities.com/sqlserverexamples#string4

  Gregory Larsen, DBA

  If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP