Im trying to populate a new column in a database query based on the content of an exisitng column.
Basically if the existing column entry has a certain format, i.e. if its an IP address the new column has a flag set to True.
Can this be done through sql?
Am i heading in the right direction with the following?
when "sql that tests format of host field" then 'Y'