Viewing 11 posts - 1 through 12 (of 12 total)
Thank you bitbucket & Grasshopper. I will try your suggestions.
September 12, 2008 at 10:27 am
RP_DBA (9/12/2008)
Do you have an example of what you're trying to achieve?
Hi. Trying to convert from float to decimal value and then report the number of characters.
i.e. float...
September 12, 2008 at 9:38 am
Chris Morris (9/10/2008)
It works on SQL Server 2k, and I'm pretty sure it will work in SQL Server 2k5 too. This is a SQL Server 2k5 forum section.
Thanks Chris. ...
September 11, 2008 at 7:20 am
Chris Morris (9/10/2008)
gpeters (9/10/2008)
Chris Morris (9/10/2008)
I've just run this again, exactly as it appears here...Strange. What type of db are you using?
You first 😉
tried oracle & sybase
September 10, 2008 at 10:45 am
Chris Morris (9/10/2008)
gpeters (9/10/2008)
Chris Morris (9/10/2008)
There isn't a Function CHAR_LENGTH in my code. Did you copy and paste?Hi. Yes I executed the exact query you supplied.
I've just run this...
September 10, 2008 at 10:18 am
Chris Morris (9/10/2008)
There isn't a Function CHAR_LENGTH in my code. Did you copy and paste?
Hi. Yes I executed the exact query you supplied.
September 10, 2008 at 9:58 am
Chris Morris (9/10/2008)
gpeters (9/10/2008)
I was hoping I could convert the float value to string in order use len in my select stmt:
i.e. select len ('-500.55') ...
September 10, 2008 at 9:30 am
Awesome. Thank you Mr or Mrs. 500.
September 10, 2008 at 8:24 am
I was hoping I could convert the float value to string in order use len in my select stmt:
i.e. select len ('-500.55') ...
September 10, 2008 at 8:04 am
Hi. I am working with a float datatype.
September 10, 2008 at 7:38 am
Hi Mr or Mrs. 500. Yes that is correct. For example:
value = -500.55
I want to get the result of 7 which includes the - sign and decimal point....
September 10, 2008 at 7:08 am
Viewing 11 posts - 1 through 12 (of 12 total)