SQL held please

[leosayer]

The statement below returns results like $8,456
SELECT to_char(val_port,'$999,999')

but no result get returned if I replace $ with £:
SELECT to_char(val_port,'£999,999')

How do I do this?

[Don]

Looks to me like this is nothing to do with SQL and everything to do with character set you have installed on the server...is US or UK?

try

SELECT '$' as Dollar, '£' as Pound


and see what you get back...

[leosayer]

Don't know which character set, but your select statement returned:

$ £

[plasticpig]

leosayer said:

The statement below returns results like $8,456
SELECT to_char(val_port,'$999,999')

but no result get returned if I replace $ with £:
SELECT to_char(val_port,'£999,999')

How do I do this?

Is this Oracle SQL?

if so try this: SELECT '£' || to_char(val_port,'999,999')

otherwise

SELECT CONCAT('£',to_char(val_port,'999,999'))

Edited by plasticpig on Thursday 28th September 12:01

[leosayer]

Thanks plasticpig, both of those work