| Author |
 Topic  |
|
|
mrtanvirali
Starting Member
Pakistan
41 Posts |
 Posted - 05/12/2008 : 02:04:45
|
dears,
how can i get the dot (.) from the value e.g. 1.235, 0.236 etc.
using sql query
regards |
Edited by - mrtanvirali on 05/12/2008 02:05:22
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 05/12/2008 : 02:07:58
|
quote:
Originally posted by mrtanvirali
dears,
how can i get the dot (.) from the value e.g. 1.235, 0.236 etc.
using sql query
regards
SELECT '.'
E 12°55'05.25"
N 56°04'39.16" |
 |
|
|
mrtanvirali
Starting Member
Pakistan
41 Posts |
Posted - 05/12/2008 : 02:18:37
|
dear,
I just want to get those records who's value are in decimal points, e.g. 3.12, 6.71 etc.
NO------------Item--------------------Qty
0460700004-- 12-05-120-013-- No-- 3.12--
0460700004-- 12-01-040-003-- No-- 12----
0460700004-- 12-01-040-005-- No-- 6.71--
0460700004-- 12-01-380-004-- No-- 6.00--
0460700005-- 12-01-140-015-- No-- 1.34--
0460700006-- 12-01-550-014-- No-- 50----
|
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 05/12/2008 : 02:21:45
|
SELECT *
FROM Table1
WHERE CAST(Qty AS VARCHAR(12)) LIKE '%.%'
E 12°55'05.25"
N 56°04'39.16" |
|
|
|
mrtanvirali
Starting Member
Pakistan
41 Posts |
Posted - 05/12/2008 : 02:24:29
|
| thanks peso for reply, the above is returning me all the records not only the decimal figures |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 05/12/2008 : 03:07:20
|
What datatype is Qty?
E 12°55'05.25"
N 56°04'39.16" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 05/12/2008 : 03:08:13
|
SELECT *
FROM Table1
WHERE FLOOR(Qty) <> CEILING(Qty)
E 12°55'05.25"
N 56°04'39.16" |
|
|
|
mrtanvirali
Starting Member
Pakistan
41 Posts |
Posted - 05/12/2008 : 03:12:58
|
ya, thats working fine, thanx,
can you define FLOOR(Qty) <> CEILING(Qty), just for understanding it |
|
|
|
madhivanan
Premature Yak Congratulator
India
22461 Posts |
Posted - 05/12/2008 : 03:14:59
|
quote:
Originally posted by Peso
SELECT *
FROM Table1
WHERE FLOOR(Qty) <> CEILING(Qty)
E 12°55'05.25"
N 56°04'39.16"
or
SELECT *
FROM Table1
WHERE Qty <> CAST(Qty as INT)
Madhivanan
Failing to plan is Planning to fail |
|
|
|
RyanRandall
Flowing Fount of Yak Knowledge
United Kingdom
1074 Posts |
|
|
mrtanvirali
Starting Member
Pakistan
41 Posts |
Posted - 05/12/2008 : 03:26:57
|
| thanks all of you, |
|
|
| |
Topic |
|
how can i get the dot (.)
