Can you please provide us some more details that what you did and what you want to achieve?

can you please post table structure and stored procedure ?

Good question 🙂

Sean Lange (6/7/2013)

---

Be very careful about using the money datatype. Given your variable names it sounds like you might be doing some calculations? The money datatype is NOT accurate when...

Andrew,

Replace your query with this one:

SET @NewPhoneNumber = REPLACE(@PhoneNumber,LEFT(@PhoneNumber,5),'')

it will works 🙂

You just switch the arguments of LEFT thats why it was not working

+1

waiting for experts views on this 😛

select LEFT('[N] 18. Is the C.B. removed from the panel? [Yes / No]',43)

Danny Ocean (6/4/2013)

---

Really easy one. Just look the first if condition, it gives result as 'Statement1 : Not null'. Now only Option 2nd having this one. I don't need to...

Easy one for the day 🙂

Here is the...

GilaMonster (6/4/2013)

---

kapil_kk (6/4/2013)

---

But I just want to clear doubt that if a single column contain 2 different values in two different rows then how AND works in that condition......

Kingston Dhasian (6/4/2013)

---

Well. That is how AND works.

SELECT STNNo FROM table1 where VoucherBookletNo = 'VVB0000021' AND VoucherBookletNo ='VVB0000025'

If your query is translated in simple English, it will be something like

Give...

Kingston Dhasian (6/4/2013)

---

You are probably looking for this, a scalar valued column cannot contain 2 different values in a single row

SELECT STNNo FROM table1 where VoucherBookletNo = 'VVB0000021' OR VoucherBookletNo...

Lokesh Vij (6/3/2013)

---

Srinivas, The idea here is we are using "TOP(6) WITH TIES", initially "TOP 6"...

NBSteve (6/3/2013)

---

For anybody like myself who was still a bit unclear, it may help to think of COALESCE as having 2 separate aspects. It needs to return a value,...