MySQL Forums
Forum List  »  Informix

What does columnname::datatype do in a where clause
Posted by: Ross Rankin
Date: July 26, 2005 02:49PM

I have a SP I'm trying to convert, the WHERE clause looks like this:
WHERE
Reseler_Profile.Status_ID = Reseller_Status.Status_ID AND
(param_Reseller_Id IS NULL OR Reseler_Profile.Reseller_Id::CHAR(4) LIKE param_Reseller_Id)

Anyone know what it does and what the MySQL Equivalent is?

Ross

Options: ReplyQuote


Subject
Views
Written By
Posted
What does columnname::datatype do in a where clause
8121
July 26, 2005 02:49PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.