Getting around the lack of IsNumeric() function in SQL CE?

SQL Server 开发者_StackOverflow社区CE (3.5) doesn't appear to support the IsNumeric function. What are some alternatives to achieve the same functionality? Specifically, how would you test whether a CAST from a string to a DECIMAL datatype will succeed in SQLCE without IsNumeric?

---

One possibility is to explicitly add an ISNUMERIC column to the table, and set the value (in your code, using your own method or a built-in .NET method) whenever the row is added or updated.

Another possibility is to use a query like this:

SELECT * FROM tbl WHERE col LIKE '%[^0-9]%'