Home Forums Article Discussions Article Discussions by Author Discuss content posted by Amol Naik Numeric or Not Numeric RE: Numeric or Not Numeric
Fal
Hall of Fame
Points: 3143
More actions
February 22, 2010 at 12:32 am
#1122729
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.