How can I change field values in a SQL statement.

[jforero]

Hi, is there any way to change the original value of a field in a SQL statement.

Say I have a REFERENCE field with 2 values A and B. Can I change the output value from A to 1 and B to 2?

The statement would be something like:

SELECT NAME, REFERENCE CHANGE(A TO 1 AND B TO 2)
FROM PRODUCT

It is not the right syntax but that is the idea.

Any help appreciated..

Jose.

 

[TomKane]

If you're SQL statement is part of a program that you're writing then I think you'd probably be better off using programming logic to do the substitutions rather than SQL