I have a table with a character column and I want to test (trigger) before
insert if the value is only numeric or no ...
Thanks for reply
by Christian FODE » Wed, 01 Jun 1994 00:39:11
Thanks for reply
by Mark Seid » Wed, 01 Jun 1994 07:42:35
unfortunately trying to compare with string constants containing
integer values doesn't work since "0123" != "123", and there's no
implicit conversion. phooey.
i suppose you could
select convert(numericaltype, column)
in fact, just doing this and rolling back in the event of an error
works for many triggers.
1. Locale Style - American numeric values to European numeric values
2. Usage of indexes with greater/lower then operators
3. Name your price $ Contract -Japan
4. TEST TEST TEST TEST TEST TEST TEST TEST TEST TEST TEST
5. connection fail '08004' & sql error 916 while creating DSN
6. Numeric versus non-numeric key values
8. Cast numeric value to datetime value
9. adodb connection to excel: recordset.fields(i).value=null for fields with numeric value
10. Oracle PL/SQL giving null values a numeric value in a stored proceedure
11. Converting a numeric value to a char value problem