Language question

[sbix]

In Oracle PL/SQL I can chain fields of a table in a unique one i.e.: Select field_1||field_2||field_3 from table; will return some rows of only one big field.
Is it possible to do in JET SQL? Is it possible to use something like that in an Access Query?

 

[RoyVidar]

In the QBE, somthing like this:

[tt] Select field_1 & field_2 & field_3 from table[/tt]

If you need some spaces etc between then field_1 & " " & field_2 in the QBE, in code single quotes in stead of double quotes.

Roy-Vidar

 

[PHV]

They are two concatenation operator with Access:
& concatenate all non null terms
+ return null if either one term is null

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244