Hi,

I am using the following select statement to inject data into my table

"INSERT INTO TblVersion([ComputerName],[Version],[Date]) VALUES ('" & compname & "','" & myversion & "','" & mytime & "' )"

This works fine.

I need some advice:
If the computer name is already in the 'computerName' field I just want to update the 'myversion' and 'mytime' fields, rather than have another entry for the same computer.

how do i perform this check?

Thabks in advance


VB2010 and SQL 2008