I am trying to extract a date string from a field, if the field populated has CED: before it.
So if the comment field shows CED:01/01/14 then give me 01/01/14
There could be characters prior or after the CED:xx/xx/xx
SUBSTRING (comment,PATINDEX('%CED:%',comment)+4,LEN(Comment)) as Date
It's pulling back data even though CED: doesn't exist in the Comment field for some reason. I am getting the date in places so it's part working.
I cannot use a where as this is an add on to a current script.
Thanks for your help. This is doing my head in!!!!