Problem with sql statement
Hi everyone.
I have found on the internet an sql statement for sorting ip adresse but it doesn't work. It always says there's an error. And i don't know how to solve it.
Here is the statement:
SELECT ipadres
FROM `tblpc`
JOIN IPPatterns
ON ipadres LIKE pattern
order by
CAST(substring(ipadres, s1, l1)as tinyint),
CAST(substring(ipadres, s2, l2)as tinyint),
CAST(substring(ipadres, s3, l3)as tinyint),
CAST(substring(ipadres, s4, l4)as tinyint)
Subject
Written By
Posted
Problem with sql statement
March 22, 2005 10:07AM
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.