I'd assume you'd use something like "instr ('abc', foob)" and convert the result > 0 into boolean. I'll be damned if I can find a good example though.<BR><BR>Uh, or CHARINDEX or POSITION or ...

I suspect that I should make a boolean SQL function CompareAddresses that returns if two addresses match or not. If anyone has ever seen SQL code to do this, I'd be estatic.