Thanks for this. It is very helpful.

Thanks for your response. Could you please, give me the code that could be used for collating tables and colums separately? Many thanks. Regards, Sahoong.

Thanks so much Jeff for your prompt and valuable response. Another question arise,

In a table with an identity column (CustID for instance), what query can I use to select the...

SRY, IT DIDN'T WORK AT ALL.

Hi Ray M,

Thanks for this.

I'll try executing it now.

Cheers.

I have attempted it. This is what i've done so far

CREATE PROCEDURE proximity_search @max_records int

@search_expression varchar(255) = '',

@x_locint = '',

@y_locint = '',

@max_distanceint = '',

@max_recordsint =...