Skip to Content
0
Former Member
May 31, 2008 at 01:29 PM

Compare two fields

25 Views

Hi

I have a table with 2 fields

ROW....FIELD1.......FIELD2

001.......XX_0020......XX_20

002.......XX_0002......XX_2

003.......XX_0200......XX_200

004.......XX_0201......XX_200

005.......XX_0037......XX_39

In select statement I would like to get only rows: 001, 002 and 003

because in these rows FIELD1 = FIELD2 if all zeros between "XX_" and first sign not equal "0" in FIELD1 are not taken into consideration.

Regards

PWnuk