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
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.