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.