How do I check if a value in a table already exists?

[xander-design]

Hi,

What's the best way to check if a table value already exists so that I can either select the value if it exists or insert a new entry into the table if it does not exist?

Thanks in advance