i need to check if the two colums has the same value or not , say for eg :

in table road , i have two colums frc(int) and frc_m (varchar[1]),

frc has values like 0,1,2,3,4,5
frc_m has values like 3,4,5,blank, it can have a blank value so it is varchar[1] , if i make it a int then blank will replaced with 0 , that i dont want .

now i want the equality check between frc and frc_m in my stored proc
like if(frc=frc_m)
then
insert into ......
end if;

please provide me the solution for that .

sanjay

Use the CAST statement to convert the int to varchar, and use the CASE statement to change the 0 to a blank.

Edit: I corrected my typo, Yes I meant CAST.

I guess Marcus meant CAST