SQL PHP HTML ASP JavaScript articles and free scripts to download
SQL Math Functions

sign sql

We can get the sign of the data by using sign function. Here is an example
select sign(-4.5); Output -1
select sign(+4.5); Output 1
select sign(4.5); Output 1
If we try a sting we will get 0 as output
select sign('abc'); // Output 0

Be the first to post comment on this article :


Post Comment This is for short comments only. Use the forum for more discussions.
Email( not to be displayed)Privacy Policy
1+2=This is to prevent automatic submission by spammers. Please enter the result of the sum as asked

HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us

©2000-2014 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer