Update command

hello,

i new transact sql please excuse question. am creating table visual studio 2008 on remote sql server 2005. main data select:

 

select        mb_kingdom, mb_phylum, mb_class, mb_order, mb_family, mb_genus, mb_species, mb_common, mb_url
from            marinebiology

 

all columns text , 255. want change genus name in row common name "california sheephead"

 

update marinebiology
set mb_genus = semicossyphus
where mb_common = california sheephead

 

right mb_genus = labridae

 

can me syntax correct can update row? time in matter appreciated.

 

reynold demarco jr.

this transact statement completed!

 

update marinebiology
set mb_genus = 'semicossyphus'
where mb_common like 'california sheephead'

 

i thank prompt attention. solution no doubt follow me throughout deployment of table see grow thousands of records.

 

gratefully,

 

reynold demarco jr

 

SQL Server  >  Getting started with SQL Server