Add a prefix to a field you select?

[JMay0816]

Can you add a text prefix to a field you select from a select statement?

Example:

Select field1, field2, field3 from table2.

I would like it to look like the following:

field1......field2........field3
Pre-<data> 34 square
Pre-<data> 22 circle


so i want to append "Pre-" to field1.

thx

 

[hoinz]

Not sure if I understood your question, but what about string concatenation:
select concat('Pre-',field1), field2, field3 from table2;

 

[colorplane]

If you're accessing the values from the resultset by name in your program you'll want to modify that query slightly:
[tt]select concat('Pre-',field1) as field1, field2, field3 from table2;[/tt]

That will preserve field1 as the name for the first record.