Formatting a String

[bjr149]

I have a string thats 50 characters. If the length of the string is 14 then i can take the first 14 characters. Which works fine...

set @InvoiceLength = LEN(@InvoiceNumber)
If @InvoiceLength < 15
begin
set @InvoiceNumberFormatted = SUBSTRING(@InvoiceNumber,1,14)
End

If the String length is Greater than 14 then i need to right justify the string and take the last 14 characters. How do i do this part. Thanks.

 

[SQLDenis]

Lookup LEFT and RIGHT in BOL

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[gmmastros]

You can do the same strick as with numbers.

Declare @Temp VarChar(50)

Set @Temp = 'Hello World'

Select Right(Replicate(' ', 14) + @Temp, 14)

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[bjr149]

Thanks this worked.