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 #374503] Fri, 15 June 2001 04:35
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

Previous Topic: Selecting an alpha character from a varchar2 field containing mostly numbers
Next Topic: Selecting an alpha character from a varchar2 field containing mostly numbers
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 14:21:50 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.