Hi all, I'm using postgres as my database server and have come across a weird problem, in my postgres stored procedure I cast a numeric field to a formatted string which includes the currency symbol, e.g. 123.76 comes out as "£123.76", viewing the output in postgres shows the output of type text which is as expected, but when I get the result of my sp into a dataset/datatable the currency symbol is missing and a leading blank is shown in its place - any ideas ?
Regards,
Peter J. Kane
Pete