Jeff - That was/is truely awesome ().  I've just used your function to select out a set of decimals from the varbinary string &...

Hi

Yes - I've already jumped though various hoops & agree that the main issue is with the representation of the [float].  Unfortunately I can't change the input data format.  If anything...

Hi John

Thanks for that and the table qualification point (I'd been struggling to find a solid reason to always specify "dbo." - since it seems redundant - and this is...

Sorry Steve - haven't got time to write a proper reply.  But - just in case everyone's going along with your view - let me say, as a long-time developer,...

Hi Dave

I think that LIKE is subject to the the normal varchar (8000)/nvarchar (4000) restriction - also in a case-insensitive env I'm not sure that LIKE will differientiate between 'AA'...

Hi Igor

Have you tried your code?

Regards.

PS As I said the quotes get a bit messy - just for the record they're all single quotes - no " (double...

Hi Kevin

No big deal - you just have some quotes missing.  You can either:

exec('UPDATE [PrintFields] Set ' + @column + ' = ''' + @value + ''' where PrintFields.PrintfieldKey =...

Thanks folks (particularly noel).

I've eventually ended up with:

select

  distinct T1.PKey

from

  Table1 T1

    join  Table2 T2 on T1.PKey = T2.PKey

    cross join TblNumber N

where

  (N.Number = 1 and

 ...

Hi Noel

Comparison is on 2 tables - same field.  Required functionality is:

if Table(prev).ntextField <> Table(curr).ntextField

  process change

Thanks.

Yes - I see where you're going.

Thanks for your help.

Yes, that is one of the ideas that I'm considering.  I've got the "idea" part ok - it's the next bit the "how" that's eluding me(!)  If I go down...

Amen to that!

My coding would be so much poorer (& slower) without these little gems.