How to set pound

Hi,
How to set pound on maney fild in MS SQL

like £#,##0.00 this we can set format on MS Access but i dont know how to set on MS SQL

Thanks
shailesh

 

Currency is stored as Decimal or Float, you format it using php or asp when you retrieve the data.

 

no i dont want to set on using script in access currance data type have format option so we can set pound format but i cant able to set pound on MS SQL database

 

Just read your original message again, you were referring to MSSQL, I was referring to MYSQL when I replied. Sorry I don't know about MSSQL.

 

as far as i'm aware there is no "currency" format in MSSQL. U store it as decimal, money or float and format on output....

 

mssql has a money field doesn't it? It doesn't treat it with a $xxx.xx but it does do 2-place decimal. Otherwise just do decimal. Hmm - it might be .NET that has a datatype of money? well... something does, lol

 

ur right, MSSQL does have a money field but it literally is a decimal type with a different name..........