Concatenating column values
I have a table having 3 columns memberfname,membermname,memberlname. I want a query where I can get a column which will have the 3 fields concatenated into one with a single space in between.
I have used query using || operator to concatenate the fields but its not working.
Can any one help?