What does columnname::datatype do in a where clause
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
Subject
Views
Written By
Posted
What does columnname::datatype do in a where clause
8608
July 26, 2005 02:49PM
6261
August 02, 2005 09:35AM
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.