Compairing two strings excluding number in sql : I have two strings stored in two different tables:

    1.) Error code=1 on A team.
    2.) Error code=2 on A team.

I want two compare these two strings in sql in such a way that numbers should be ignore i.e. when I compare these string I should get output of the condition as true. How can i do this?