Thanks I thought it would be simple but I've never come across that issue 🙂

GilaMonster (8/20/2014)

---

Escape the quote by doubling it

LEFT(LastName,2) = 'O''' -- That's two single quotes to escape...

Tania Mofflin (6/3/2014)

---

OK now I remember why I converted the data to...

OK now I remember why I converted the data to VARCHAR in...

OK so I'm not really totally around the difference between CAST and CONVERT but I will have a read up on them for future reference, always developing my skills.

I kind...

This comes back with the following error -

Msg 8114, Level 16, State 5, Line 1

Error converting data type varchar to numeric.

Seems to be an issue with how I've converted...

Yes that's what I mean, it's just my amatuer terminology. Thanks for your help on this one.

Thankyou, obvious now that I see it 🙂

This doesn't work, it only returns the result of the first query

Payables TB

1551651.47

I come from an accounting background and am self taught on SQL coding, am not sure what is meant by DDL but I will have a read and learn.

I am...

Thanks for the responses, my skills are developing each day but the other responses at this stage are a bit complex for me to follow. This one works for me.