leading blanks

Question

Post reply

leading blanks

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323741 More actions · Answer 1

i think you jsut need to wrap the Tiutle column with the isnull function:

select RIGHT(' '+CONVERT(VARCHAR,ISNULL(Title,'')),40) AS Title

from ADDRESS;

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 2

Hi there, try this:

SELECT ISNULL(RIGHT(' '+CONVERT(VARCHAR,Title),40) , REPLICATE (' ',40))

Tell us if that worked for you!

g.riensche Valued Member Points: 64 More actions · Answer 3

thanks a lot guys! Both solutions are working.

regards,

Garvin