<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
On 6/14/2011 11:37 AM, Ivan Smahin wrote:
<blockquote cite="mid:4DF71DB0.2060805@paradigmasoft.com"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<br>
For example - you may apply "format" sql-function to get
different results:<br>
<br>
<span class="Apple-style-span" style="border-collapse: separate;
color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-style:
normal; font-variant: normal; font-weight: normal;
letter-spacing: normal; line-height: normal; orphans: 2;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 2; word-spacing: 0px; font-size: medium;"><span
class="Apple-style-span" style="color: rgb(51, 51, 51);
font-family: Geneva,Arail,Helvetica,sans-serif; font-size:
12px; line-height: 18px; text-align: justify;">
<pre class="code sql" style="padding: 0.5em; margin: 0px 0px 1em; font-size: 12px; border: 1px dashed rgb(204, 204, 204); color: rgb(51, 51, 51); overflow: auto; background-color: rgb(247, 249, 250); width: auto ! important;"><span class="kw1" style="padding: 0px; margin: 0px; color: rgb(177, 177, 0);">SELECT</span> <span class="search_hit" style="padding: 0px; margin: 0px; color: rgb(51, 51, 51); background-color: rgb(255, 255, 153);">FORMAT</span><span class="br0" style="padding: 0px; margin: 0px; color: rgb(102, 204, 102);">(</span><span class="nu0" style="padding: 0px; margin: 0px; color: rgb(204, 102, 204);">123456.123456</span><span class="sy0" style="padding: 0px; margin: 0px; color: rgb(102, 204, 102);">,</span> <span class="st0" style="padding: 0px; margin: 0px; color: rgb(255, 0, 0);">'###.##'</span><span class="br0" style="padding: 0px; margin: 0px; color: rgb(102, 204, 102);">)</span>;</pre>
</span></span></blockquote>
It must be:<br>
SELECT FORMAT(f1, '###.###') from t1;
<blockquote cite="mid:4DF71DB0.2060805@paradigmasoft.com"
type="cite">1<br>
1.1<br>
1.123<br>
12345678901.123<br>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
<a class="moz-txt-link-freetext" href="http://www.valentina-db.com">http://www.valentina-db.com</a></pre>
</body>
</html>