SQL Recipes (Beta II)
A FREE cookbook for SQL queries and examples
Register FAQ Search Today's Posts Mark Forums Read

SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it.

Go Back   SQL Recipes a FREE cookbook of SQL queries and examples > SQL queries and examples > SQL - Questions and Answers

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread
  #1 (permalink)  
Old 12-13-2006, 03:44 PM
Thomas Schenkeli
 
Posts: n/a
Default Oracle dialect question:

How do i compare NUMBER to VARCHAR?


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?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Edit/Delete Message Reply With Quote

ANSWER(S):

  #2 (permalink)  
Old 12-14-2006, 12:44 AM
EvilOverlord EvilOverlord is offline
Junior Member
 
Join Date: Dec 2006
Posts: 2
EvilOverlord is on a distinguished road
Default ANY answer. Re: How do i compare NUMBER to VARCHAR?

Use the CONVERT command:
WHERE mynumber = CONVERT(int,mycharacters)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-02-2008, 08:17 AM
Unregistered
 
Posts: n/a
Default ANY answer. Re: How do i compare NUMBER to VARCHAR?

Hi

you can use function to_number to convert varchar to number

hope this works

regds
Ankur
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Edit/Delete Message Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Moderation Tools:



All times are GMT. The time now is 07:41 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0
Copyright (c) 2006-2007 SQL Recipes

1 2 3 4 5 6 7