How do i compare NUMBER to VARCHAR?

#1 (**permalink**) 12-13-2006, 03:44 PM

I have to fields with numeric values that i want to compare, however one of this fields has not been declared as number but as varchar, what do i have to do?

EvilOverlord · #2 (**permalink**) 12-14-2006, 12:44 AM

Use the CONVERT command:


WHERE mynumber = CONVERT(int,mycharacters)

#3 (**permalink**) 02-02-2008, 08:17 AM

Hi

you can use function to_number to convert varchar to number

hope this works

regds
Ankur

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

User Name		Remember Me?
Password

vBulletin Message

Cancel Changes

How do i compare NUMBER to VARCHAR?

ANSWER(S):