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