Re: SELECT
From: Marvin <ales.romaniuk@zag.si>
>
>I have two questions regarding SELECT statement.
>
>1. If I do SELECT statement, I get each fields in a record in
> seperate row:
> MYID 1
> MYNAME Name
>
> MYID 2
> MYNAME Name2
> ...
>
> I would like to get output like:
> MYID MYNAME
> 1 Name
> 2 Name2
> ...
>
> How to change that
Try sqlcmd from http://www.iiug.org. dbaccess automatically wraps at 80
characters. Or try selecting only the first N characters from your text
field. (But that might not be what you want.)
>2. I would like to replace field name with something else
> like
> SELECT "Id:"=MYID,"Name:"=MYNAME FROM TABLE (this works in SyBase)
>
> Id Name
> 1 Name
> 2 Name2
select myid id, myname name from table.
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com