I have a table of strings categorized by string type and unique id
e.g.
stringTypes table (sType, sDescription)
0 vanilla
1 ip address
2 mail address
stringValues table (sId, sType, sValue)
1 0 foobar
2 2 123 Main Street
3 1 123.123.123.123
I want to select ip address type strings and order them by ip address. However I can not find a function that returns an inet given a string.
e.g.
select sValue from stringValues A, stringTypes B
where A.sType = B.sType and B.sType = 1
order by [**** function that converts string to INET ****] (A.sValue);
TIA
Richard DeVenezia