Looking for help with SQL

[kirkm]

Hi

How would sql be written to see if both items in 2 fields are the same ?

One field is a string and the other a number, or group of delimited numbers.

I'm wanting to output instances where the string is not the same for any number(s).

Is it possible?

Thank you.

 

[bparkinson]

I'm pretty sure you will need to convert the integer to a string, and then compare.

 

[kirkm]

Thanks very much, that's an excellent idea and your assumptions are correct.
In fact, there's a spare field available - and yes the number is a string as I've used Hex so wildcard matching is possible.
As this evolves I'm not quite sure of results... or other problems. Everyone tells me I'm doing it wrong - but I can only try and see!

Cheers - Kirk

 

[vbaInet]

If all you're doing is checking whether String is contained in Number then here:

IIF(Nz(instr(1,[[COLOR=red]String[/COLOR]], [[COLOR=red]Number[/COLOR]] & ""),-2) < 0, True, False)

Then you can filter for True.