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 |
|
ljp099
Yak Posting Veteran
79 Posts |
 Posted - 2008-01-19 : 16:19:02
|
| DocID (int) contains values:DocID103374510337890Im trying to form a select statment where 1033 is removed from the value, so that only the value after 1033 is selected. What is the easiest method?Something like this perhaps?select * downloads where Right(doc_id, 4, Len(doc_id)) = 745 |
|
|
singularity
Posting Yak Master
153 Posts |
Posted - 2008-01-19 : 20:14:57
|
| select substring(DocID,4,len(DocID)) |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-20 : 08:37:46
|
quote:
Originally posted by singularity
select substring(DocID,5,len(DocID))
you need to start from 5th char |
|
|
|
|
|
|
Help with select statement