Home » RDBMS Server » Server Administration » Selecting an alpha character from a varchar2 field containing mostly numbers
Selecting an alpha character from a varchar2 field containing mostly numbers [message #374500] Fri, 15 June 2001 04:30 Go to next message
John Guy
Messages: 8
Registered: June 2001
Junior Member
When I try to to_number a varchar2 field I get an invalid number error, I assume one of the fields is holding an alpha charater. Is there a special character that can be used in the where claus to indicate an alpha charater search i.e what can I replace the question mark with in this where claus....
Where attribute2 LIKE '%?%'

Report message to a moderator

Re: Selecting an alpha character from a varchar2 field containing mostly numbers [message #374523 is a reply to message #374500] Fri, 15 June 2001 18:31 Go to previous message
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
remember to consider !@#$%+_-()... too

Report message to a moderator

Previous Topic: Selecting an alpha character from a varchar2 field containing mostly numbers
Next Topic: Windows 2000 & Oracle 8i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 06 18:09:19 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.