hi,

can anyone tell me how i can replicate the Access function NZ please?

i want to use it with charindex when parsing text strings

many thanks