brilliant,

It works, I used the following within my query...

,

(datalength(wk.SESS_PER_WEEK) - datalength(replace(wk.SESS_PER_WEEK, 'X', ''))) as 'X',

 (datalength(wk.SESS_PER_WEEK) - datalength(replace(wk.SESS_PER_WEEK, '/', ''))) as '/',

 (datalength(wk.SESS_PER_WEEK) - datalength(replace(wk.SESS_PER_WEEK, '\', ''))) as '\',

 (datalength(wk.SESS_PER_WEEK) - datalength(replace(wk.SESS_PER_WEEK, '#',...

Hi,

Thanks for that. I dont really want to go the temporary table route because I have got throusands of records that I need to do this too and then...

Thanks for that,

Its good to know that someone else has had the same problem with this too. I did it  very simply by just making a table from the original...

Hello again,

Its very strange, filters just dont work but I do a MAKE table from the linked table and the filters work fine so this is how I have resolved...

Brilliant,

Thanks you so much for that. I knew there was going to be an option somewhere but I wouldnt have found that one for a long time.

Everything is exporting properly...

Ah ha,

Not sure how I managed it but I used -1 against the query and this works fine.

Thanks

Debbie

Just tried it and it works which is great because now I can exchange my <> clause in all my tables where I may have problems because of NULL fields.

Just...

Thanks for that,

I tried the above but didnt get any results back.

SELECT ID.MNAME, sd.*

FROM dbo.Import_FULL sd INNER JOIN #ATTENDANCES_a ID

ON  sd.Forename = ID.FNAME AND sd.DateOfBirth = ID.DOB AND sd.Surname = ID.SNAME

AND sd.DFES...

Thanks for that. I was hoping to not go for an outer join though in this case. Maybe a conversion or something in the where clause to convert all Nulls...

I have used that but Ive deleted all the 10 records rather than just the 5 records where the FROM date is earlier than the other from date.

Whoops, Ill have...

Excellent,

This might be better for me. I will try and get this into my query and let you know how it goes.

Debbie

Thanks for that. I will give it a go!

Debbie

Thanks for that,

It looks a bit scary,but I will definitely give it a go!

Debbie

I cannot thank you enough. Its worked perfectly. Although now I need to sort out all those records where there is an open attendance (WHERE PAT_TO_DATE IS NULL) which should...

I cannot thank you enough. Its worked perfectly. Although now I need to sort out all those records where there is an open attendance (WHERE PAT_TO_DATE IS NULL) which should...