Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ranjeetsingh_6
Posting Yak Master
125 Posts |
 Posted - 2006-09-04 : 03:33:50
|
| Hi I have a Table VEHICLETRACK .This Table have a column Latitude its datatype is float . I want to get substring(at 8 digit) of column Latitude.Then i want to perform some task on this substring and again get substring of column Latitude and again perform some task .Means I want a Loop to get substring then perform some task on this substring then again get substring then perform task .... untill all rows end of column.Ranjeet Kumar Singh |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-09-04 : 03:36:24
|
convert from float to varchar() and use substring() on it
KH |
 |
|
|
kbatna59
Starting Member
1 Post |
Posted - 2011-02-21 : 02:36:07
|
| Try to change the float as char in the following formatselect Substring(cast(account as char),1,2)as "Acct",Kam |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-02-21 : 02:45:20
|
Kam, in case you didn't notice that was a 5 year old thread.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-02-21 : 03:21:41
|
quote:
Originally posted by khtan
Kam, in case you didn't notice that was a 5 year old thread.
KH[spoiler]Time is always against us[/spoiler]
It seems that for the first time posters it does not matter they always want to reply to the topic to which they know the answerMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Substring of float value and performTaskon this