simple delete statement

Question

Post reply

simple delete statement

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

wannalearn SSChasing Mays Points: 649 More actions · Answer 1

Update the values with ABCD0123 if 3 digit

update the values with ABCD1234 IF 4 digit

for the same column now.

what would be sql statement?

Thanks

GSquared SSC Guru Points: 260824 More actions · Answer 2

Same thing, just replace 'ABCD' in either one.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 3

wannalearn (11/15/2010)
Update the values with ABCD0123 if 3 digit
update the values with ABCD1234 IF 4 digit
for the same column now.
what would be sql statement?
Thanks

You just changed the question around. are you trying to remove ABCD or simply trying to pad the number to make the column a consistent length?

Also - are you trying to to all of this in one single step based on the values you just extracted during the previous question?

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

wannalearn SSChasing Mays Points: 649 More actions · Answer 4

Thank you all for your input. I just had to update it which is done now.