June 26, 2011 at 12:22 pm
I have a query that needs to output fixed length fields.
Query has:
convert(char(20), field name) as field heading but output is not 20 character field.
Any ideas?
June 26, 2011 at 1:09 pm
Do you have ANSI padding on ?
June 26, 2011 at 1:35 pm
That worked - 2 more questions
How can I change NULL results to be blank instead of NULL?
How can I save the results without , between fields?
Thanks,
June 26, 2011 at 4:01 pm
June 26, 2011 at 5:42 pm
Jim Woods (6/26/2011)
How can I change NULL results to be blank instead of NULL?
ISNULL(somecolumn,'')
How can I save the results without , between fields?
Concatenate the columns into one big column.
ColumnA+ColumnB+ColumnC+....
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy