Fal (2/22/2010)
ISNUMERIC is more general than CONVERT. The following is also valid (in 2008):SET @PrincipalAmount = '100e2'
It will convert to float, but not money. With the QotD I was more concerned about the decimal place with no trailing zeroes.
S.
i found out the "e2" issue by accident. One of our customers likes using those in conjunction with numbers for locations ... WTH