Post reply

set my header

  • June 7, 2006 at 2:34 am

    #114010

    need help.......

    to set my header with space

    ex : column name "user account"

    and how to set my output without table, just a list

    thanx

  • June 7, 2006 at 6:41 am

    #642246

    This is a duplicate post and was answered already......but for the record...

    Enclose the header with square brackets or single quotes.

    SELECT mycol AS 'User Account'

    or

    SELECT mycol AS [User Account]

    -SQLBill

Viewing 2 posts - 1 through 1 (of 1 total)

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