Combine data from different fields

[aas1611]

I have the following problem.

Let's say I have a table that looks like this:

Num1 Num2
---- ----
001 002

Both fields are text type. What am I supposed to do to get the result in one column such as this:
EDE001_002

which EDE is just some added string (could be numbers too as text), and Num1 ist connected to Num2 with an underscore (_).

Or can I do this easier with PHP? If yes, how?

Thanks for any help and suggestions!

 

[TonyGroves]

How about:
[tt]
SELECT CONCAT('EDE',num1,'_',num2)
FROM ...
[/tt]