Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Raiserror and numeric parameters (real, float)
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01226806
Message ID:
01226878
Views:
26
Borislav,

>No need of LTRIM(STR(....)) if you CAST the variable to varchar()

I need to show this information with two decimals. Using Varchar, returns it with 3 decimals.

In addition, Brazilians use , (common) as decimal separator, and Cast returns . (point) as decimal separator.

Any way, thanks for your answer... I'm still learning SQL and this kind of tips are very interesting to learn!

Thanks!

Rodolfo
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Rodolfo Duarte
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform