Finding the presence of a value in two separate columns.

[darrellbutler]

Hi, I need to check whether or not a membership code exists in two columns within the same table.

Has anybody got any ideas on how i can acheive this?

Many thanks

Darrell.

[#2]

Sum(if(Colum1=Column2,1,0))

by using this as expression u will get how many values match between to column.