Sorry, typo in the SELECT, just one comma after MyColumn2. Greetings.
Walter. On Thu, Apr 23, 2015 at 8:00 PM, Walter R. Ojeda Valiente < sistemas2000profesio...@gmail.com> wrote: > You can use SIMILAR TO, something like it: > > SELECT > MyColumn1, > MyColumn2,, > MyColumn3 > FROM > MyTable > WHERE > MyColumn1 SIMILAR TO '[[:DIGIT:]]*' > > Where just the digits 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 are valid. > > If you need the decimal point too, try something like it, where the > decimail point is required: > > SIMILAR TO '[[:DIGIT:]]*.[[:DIGIT:]]*' > > And if you can have integers and floats (decimal point can be, but not > required), you can try: > > SIMILAR TO '[[:DIGIT:]]*.?[[:DIGIT:]]*' > > And, finally, if you can read Spanish, take a look at: > > https://firebird21.wordpress.com/2014/04/27/usando-similar-to/ > > https://firebird21.wordpress.com/2014/11/25/validando-un-e-mail/ > > Greetings. > > Walter. > > > On Thu, Apr 23, 2015 at 2:34 PM, sboyd...@gmail.com [firebird-support] < > firebird-support@yahoogroups.com> wrote: > >> >> >> Is there any way, within a stored procedure, to test a VARCHAR to see if >> it contains a valid number? I have a parameter that can contain different >> types of value and it would be nice to be able to know if CAST(param as >> BIGINT) is going to fail before an exception is thrown. >> >> >> >> >> > >