Comparison of character and number

[dharmu131983]

Hi All,
I have to join two tables,table A is having a column Store_id as number ei 1234
and table B having the column as character as 'SOLUTION STATION - # 1234'
i have used the condition as follows:
where (replace(B.stor e_name,'SOLUTIO N STATION - # ',''))=to_char( A.STORE_ID)
i am getting error as "invalid number"
can any one suggest me the right solution for this ?
Thanks in advance.
dharmendra

[amitpatel66]

Remove the to_char from the right hand side and try executing the query