Hi all.
I have a problem:
When I compare two strings in mask (x.x.x.x) the comparation is not true (for my question
:D)... look:
select '3.2.0.13' > '3.2.0.2' -> FALSE
I want this command return TRUE, but it is returning FALSE.
But, if I put a space first into the smaller string the camparation will returns what I
want:
select '3.2.0.13' > ' 3.2.0.2' -> TRUE
How can I check it? There is a way to correct my problem? The string is like a IP-ADDRESS
where 192.168.0.13 is better than 192.168.0.2, but it is not a IPADDRESS column, it is a
Version of file (version 3.2.0, version 3.2.1, etc...)
Thanks for all.