See i was thinking more towards a charindex but your snippet works perfectly.

Thank you 😀

Hi GilaMonster

Thats exactly what i want,

So if a order has 5 items attached to it i need to check the condate on each for a value if any of...

SSChampion Thank you so much, thats perfect, one other thing if i may, say for example i have an order with two items, and one item was completed on 01/03/2012...

Im using this one

SELECT 0 AS IntUserID, 'Select...' AS chrFullname

UNION ALL

SELECT U.intUserID, U.chrUnAllocatedUser

from wrp_UnAllocatedUser as U

UNION ALL SELECT wrp_sys_User.IntUserId, wrp_sys_User.chrForename + ' ' + wrp_sys_User.chrSurname AS chrFullName

FROM wrp_team INNER...

Hi Lutz,

Thank you for the reply and additional information i will take a look at all different functions in great detail.

Thanks again 🙂

Yeah i know i put that there because i thought ISNULL( your conditions go here) must of read some information wrong 🙁

I See just had a look, Seems ideal but i think i may have the syntax wrong can you check for me? as you stated you should only have one...

oo i see, Sorry SQL isnt my Strong point as you can tell,

I have just been informed that the call loggin system im currently making will be giving the user...

Hi Thanks for the response

am i missing a quote or something because im getting incorrect syntax near the keyword 'Set'

UPDATE wrp_Work

SET chrWorkDesc = ISNULL(@spDescription, chrWorkDesc),

...

Ok thanks for the information, ill take a look at that

Just another question

Ok taking in to consideration that you cant use the IF statement within Where Clauses is there...

Oh ok thanks, iv only ever used SQL for bits and pieces but i want to go more in depth with it 🙂 thanks for your advice and notes 🙂

ooo well would you look at that haha!

Thanks for the response 🙂