Load 123 how to make it display as SGD123 ?

[#1]

Hi All

i have load 1 row of data on  filed = LIST_PRICE INTO qv.

The value display is 123

May i know how to make the value display as SGD123 ?

[michael_maeuser · Accepted solution]

is that what you want?

[senpradip007]

Try this

='SGD' & LIST_PRICE

[#4]

Hi All

Sorry i never explan enough for my requirement.  in my actual application , i have to load different set of price list .for example :-

if pricing list base on USD , the list price will display as USD123.

if pricing list base on EURO , the list price will display as EURO123.

My imagine script should be :-

     [List Price] AS LIST_PRICE_,

Above script will load the [LIST PRICE]

     'SGD'&[List Price] AS LIST_PRICE,

But it cannot work......EDIT , i just try it work fine . Thank you case closed.

Paul