Cory,
I'm not sure I understand what you're asking. MySQL casts the data to the
appropriate column type when that data is entered into the database. Data
in a varchar column is always stored as a string, just as data in an INT
field is always going to be of type INT.
-Rob
-----Original Message-----
From: Cory Lamle [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 2:40 PM
To: MySQL LIST
Subject: SQL Syntax
Contents are Direct Alliance Corporation CONFIDENTIAL
-
How do you type check in mysql. I have a column of type varchar(20) with
both floats and strings. Is there a way to check the type?
Example:
Select
If(is_float(col1), 'is a float', 'not a float') as
type
From table
Thxs
Cory
This message is for the designated recipient(s) only and contains Direct
Alliance Corporation privileged and confidential information.
If you have received it in error, please notify the sender immediately and
delete the original.
Any other use of this email is prohibited.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
