SQL SELECT ADD A FIELD

[Scott24x7]

It is possible in the SELECT (SQL) Statement to add a field that doesn't exist in the target table?

For Instance:

SELECT FirstName, LastName, Age, Attendee(as a logical) FROM GUESTLIST INTO TABLE CONFIRMED

Where "Attendee" doesn't exist in the table "GUESTLIST" but want to add it as a logical field?
Is this possible?


Best Regards,
Scott
ATS, CDCE, CTIA, CTDC

"Everything should be made as simple as possible, and no simpler."

 

[Mike Lewis]

Certainly.

SELECT FirstName, LastName, Age, [b].F. AS Attendee[/b] FROM GUESTLIST INTO TABLE CONFIRMED

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Mike Lewis]

One caveat: Make sure the new field is wide enough to hold the required data. This doesn't apply to logical fields, dates or datetimes (which are fixed length), but it could trip you up with characters and numbers. For example:

[tt]SELECT ID, Name, 0 AS Salary FROM Employee[/tt]

This will give you a Salary field which is only one character wide. Better do this:

[tt]SELECT ID, Name, CAST(0 AS N(10,2)) AS Salary FROM Employee[/tt]

Similarly, rather than this:

[tt]SELECT ID, Name, " " AS Department FROM Employee[/tt]

do this:

[tt]SELECT ID, Name, SPACE(15) AS Department FROM Employee[/tt]


Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Scott24x7]

Wow, that's just awesome, and just totally fixed my grid control issue.

Best Regards,
Scott
ATS, CDCE, CTIA, CTDC

"Everything should be made as simple as possible, and no simpler."