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 |
|
sharathkatpally
Starting Member
4 Posts |
 Posted - 2009-03-30 : 11:18:34
|
| Hello, I have a column with value 200801. I want the values to be returned as 2008. In oracle i use trunc(column1/100) then i get 2008. Is there any similar function in sql server. please help |
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-03-30 : 11:29:32
|
| select left(200801,4) |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-03-31 : 03:03:21
|
| select 200801/100MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
trunc