Comparar 2 cadenas con diferentes formatos.

[hach]

Hola
si usas firebird (y supongo que interbase tambien) puedes compilar la UDF

substr

* Functional description:
* substr(s,m,n) returns the substring
* of s which starts at position m and
* ending at position n.
* Note: This function is NOT limited to
* receiving and returning only 255 characters,
* rather, it can use as long as 32767
* characters which is the limit on an
* INTERBASE character string.
* Change by Claudio Valderrama: when n>length(s),
* the result will be the original string instead
* of NULL as it was originally designed.


y con esta podrias hacerlo dentro de una consulta sql

Saludos

Pablo