Using 'AS' for two fields

[jalbao]

is it possible to use the AS function over two fields?

looking to do something like this:
SELECT (field_1,field_2) AS foo
FROM table

now when i call the 'foo' variable the values of field_1 and field_2 are returned.

tia

 

[ctarr]

If these are text fields you can do something like Field_1 + ' ' + Field_2 as Foo.

Craig

 

[jalbao]

thanks a bunch craig