UPDATE tblStation SET Ship='90BU' WHERE Ship='A.BORISOV' 
UPDATE tblStation SET Ship='90OT' WHERE Ship='A.OTKUPHIK'
UPDATE tblStation SET Ship='90AT' WHERE Ship='A.VIL"KISK'
UPDATE tblStation SET Ship='90UQ' WHERE Ship='ADJARIY'   
UPDATE tblStation SET Ship='90AH' WHERE Ship='AHILL'     
UPDATE tblStation SET Ship='90AJ' WHERE Ship='AK.BERG'   
UPDATE tblStation SET Ship='90BR' WHERE Ship='AK.HULEYKI'
UPDATE tblStation SET Ship='90KN' WHERE Ship='AK.KNIPOVI'
UPDATE tblStation SET Ship='90LG' WHERE Ship='ALAID'     
UPDATE tblStation SET Ship='9014' WHERE Ship='ANDROMEDA' 
UPDATE tblStation SET Ship='9062' WHERE Ship='ARGUN"'    
UPDATE tblStation SET Ship='90AZ' WHERE Ship='ARTEMIDA'  
UPDATE tblStation SET Ship='RUAL' WHERE Ship='ATLANTIDA' 
UPDATE tblStation SET Ship='90A2' WHERE Ship='AYKS'      
UPDATE tblStation SET Ship='90AI' WHERE Ship='AYSBERG'   
UPDATE tblStation SET Ship='9066' WHERE Ship='BOGUCAR'   
UPDATE tblStation SET Ship='90uk' WHERE Ship='BAHCISARAY'
UPDATE tblStation SET Ship='90BW' WHERE Ship='BOGUSLAV'  
UPDATE tblStation SET Ship='90WL' WHERE Ship='D.ZELENSI' 
UPDATE tblStation SET Ship='90EV' WHERE Ship='EVRIKA'    
UPDATE tblStation SET Ship='90fn' WHERE Ship='F.NANSEN'  
UPDATE tblStation SET Ship='90CB' WHERE Ship='GEMMA'     
UPDATE tblStation SET Ship='90CC' WHERE Ship='GENICESK'  
UPDATE tblStation SET Ship='908V' WHERE Ship='GEORGIEVSK'
UPDATE tblStation SET Ship='90S3' WHERE Ship='HTORM'     
UPDATE tblStation SET Ship='90IL' WHERE Ship='ISSLEDOVAT'
UPDATE tblStation SET Ship='90KL' WHERE Ship='KAHALOT'   
UPDATE tblStation SET Ship='909B' WHERE Ship='KALMIKOVO' 
UPDATE tblStation SET Ship='90KS' WHERE Ship='KAP.HAYTAN'
UPDATE tblStation SET Ship='90CF' WHERE Ship='KAPITAN_DE'
UPDATE tblStation SET Ship='90CJ' WHERE Ship='KOKHAYSK'  
UPDATE tblStation SET Ship='9059' WHERE Ship='KORABLESTR'
UPDATE tblStation SET Ship='909C' WHERE Ship='KORENOVSK' 
UPDATE tblStation SET Ship='90EP' WHERE Ship='LENA'      
UPDATE tblStation SET Ship='902F' WHERE Ship='LENSK'     
UPDATE tblStation SET Ship='90LV' WHERE Ship='LEV_TITOV' 
UPDATE tblStation SET Ship='90ML' WHERE Ship='LOMONOSOV' 
UPDATE tblStation SET Ship='90LY' WHERE Ship='LUBLINO'   
UPDATE tblStation SET Ship='909E' WHERE Ship='MAKHEEVO'  
UPDATE tblStation SET Ship='90CN' WHERE Ship='MENZELINSK'
UPDATE tblStation SET Ship='90CO' WHERE Ship='MIH.VERBIS'
UPDATE tblStation SET Ship='90MS' WHERE Ship='MIHAIL_SOM'
UPDATE tblStation SET Ship='90CT' WHERE Ship='multanovsk'
UPDATE tblStation SET Ship='90SS' WHERE Ship='MUYNAK'    
UPDATE tblStation SET Ship='90KV' WHERE Ship='N.KONONOV' 
UPDATE tblStation SET Ship='90MN' WHERE Ship='N.MASLOV'  
UPDATE tblStation SET Ship='90NR' WHERE Ship='NEREY'     
UPDATE tblStation SET Ship='90NE' WHERE Ship='NERPA'     
UPDATE tblStation SET Ship='90OB' WHERE Ship='OB"'       
UPDATE tblStation SET Ship='90PX' WHERE Ship='OBVA'      
UPDATE tblStation SET Ship='90OG' WHERE Ship='OKEANOGRAF'
UPDATE tblStation SET Ship='90TC' WHERE Ship='OTTO_HMIDT'
UPDATE tblStation SET Ship='90CT' WHERE Ship='P.MUL"TANO'
UPDATE tblStation SET Ship='90YH' WHERE Ship='PAVEL_KAYK'
UPDATE tblStation SET Ship='90PS' WHERE Ship='PERSEY'    
UPDATE tblStation SET Ship='90P6' WHERE Ship='PERSEY-II' 
UPDATE tblStation SET Ship='90PW' WHERE Ship='PERSEY-III'
UPDATE tblStation SET Ship='RUPK' WHERE Ship='PETRKOTTSO'
UPDATE tblStation SET Ship='90PK' WHERE Ship='POISK'     
UPDATE tblStation SET Ship='90PO' WHERE Ship='POLYRNIK'  
UPDATE tblStation SET Ship='90CZ' WHERE Ship='POLYRNOE_S'
UPDATE tblStation SET Ship='90MY' WHERE Ship='PROF.MESYS'
UPDATE tblStation SET Ship='90CQ' WHERE Ship='PROF.MOLCA'
UPDATE tblStation SET Ship='905G' WHERE Ship='PROF.S.DOR'
UPDATE tblStation SET Ship='9060' WHERE Ship='RINDA'     
UPDATE tblStation SET Ship='90SN' WHERE Ship='S.ANDREEV' 
UPDATE tblStation SET Ship='90SP' WHERE Ship='SEVASTOPOL'
UPDATE tblStation SET Ship='90s5' WHERE Ship='SEVER'     
UPDATE tblStation SET Ship='90BR' WHERE Ship='shuleykin' 
UPDATE tblStation SET Ship='90br' WHERE Ship='SHUL'      
UPDATE tblStation SET Ship='90SI' WHERE Ship='SIBIRYKOV' 
UPDATE tblStation SET Ship='90RJ' WHERE Ship='SIVIL"SK'  
UPDATE tblStation SET Ship='90WF' WHERE Ship='SLAVGOROD' 
UPDATE tblStation SET Ship='9063' WHERE Ship='SRT-331'   
UPDATE tblStation SET Ship='90C5' WHERE Ship='SULOY'     
UPDATE tblStation SET Ship='90TP' WHERE Ship='TOPSEDA'   
UPDATE tblStation SET Ship='90BF' WHERE Ship='V.BUYNISKI'
UPDATE tblStation SET Ship='90VY' WHERE Ship='VIL"NUS'   
UPDATE tblStation SET Ship='90BC' WHERE Ship='VITEBSK'   
UPDATE tblStation SET Ship='90VZ' WHERE Ship='VIZE'      
UPDATE tblStation SET Ship='90VS' WHERE Ship='VOSHOD'    
UPDATE tblStation SET Ship='90VQ' WHERE Ship='VOZROJDENI'
UPDATE tblStation SET Ship='908U' WHERE Ship='VS.BEREZKI'
UPDATE tblStation SET Ship='90ZE' WHERE Ship='ZARNISA'   
UPDATE tblStation SET Ship='90Z4' WHERE Ship='ZUB'       
UPDATE tblStation SET Ship='06mt' WHERE Ship='met82'     
UPDATE tblStation SET Ship='06mt' WHERE Ship='met88'     
UPDATE tblStation SET Ship='06AQ' WHERE Ship='Polarstern'
UPDATE tblStation SET Ship='06AZ' WHERE Ship='VALDIVIA'  
UPDATE tblStation SET Ship='06az' WHERE Ship='val88'     
UPDATE tblStation SET Ship='06az' WHERE Ship='val89'     
UPDATE tblStation SET Ship='18HU' WHERE Ship='HUDSON'    
UPDATE tblStation SET Ship='18hu' WHERE Ship='hud82'     
UPDATE tblStation SET Ship='314U' WHERE Ship='BARTLETT'  
UPDATE tblStation SET Ship='316N' WHERE Ship='KNORR'     
UPDATE tblStation SET Ship='31LY' WHERE Ship='LYNCH'     
UPDATE tblStation SET Ship='31NO' WHERE Ship='NORTHLAND' 
UPDATE tblStation SET Ship='31WE' WHERE Ship='WESTWIND'  
UPDATE tblStation SET Ship='32pz' WHERE Ship='POLAR_STAR'
UPDATE tblStation SET Ship='46BS' WHERE Ship='BJARNI_SAE'
UPDATE tblStation SET Ship='58GS' WHERE Ship='GOSARS'    
UPDATE tblStation SET Ship='58AA' WHERE Ship='HAAKONMOSB'
UPDATE tblStation SET Ship='58AA' WHERE Ship='HAKON_MOSB'
UPDATE tblStation SET Ship='58aa' WHERE Ship='mos89'     
UPDATE tblStation SET Ship='58JH' WHERE Ship='JOHAN_HJOR'
UPDATE tblStation SET Ship='58JH' WHERE Ship='JOHANHJORT'
UPDATE tblStation SET Ship='58KB' WHERE Ship='KVITBJORN' 
UPDATE tblStation SET Ship='58LA' WHERE Ship='LANCE'     
UPDATE tblStation SET Ship='58MS' WHERE Ship='MICHAELSAR'
UPDATE tblStation SET Ship='58PO' WHERE Ship='POLARBJORN'
UPDATE tblStation SET Ship='58AB' WHERE Ship='POLARQUEEN'
UPDATE tblStation SET Ship='67CE' WHERE Ship='OCEANIA'   
UPDATE tblStation SET Ship='74CZ' WHERE Ship='CIROLANA'  
UPDATE tblStation SET Ship='74EH' WHERE Ship='ERNEST_HOL'
UPDATE tblStation SET Ship='74JC' WHERE Ship='JAMESCLARK'
UPDATE tblStation SET Ship='77YM' WHERE Ship='YMER'                   
                                                      
                                                      
UPDATE tblStation SET Ship='90P2' WHERE Ship='PINRO' AND cast([Date] as datetime)<'01/01/1992'                                                                 --UYSC                                                   
UPDATE tblStation SET Ship='RUP2' WHERE Ship='PINRO' AND cast([Date] as datetime)>='01/01/1992'                                                                       --(UYSC) AS OF 1/1/1992                             
UPDATE tblStation SET Ship='909H' WHERE Ship='SMOLENSK' AND cast([Date] as datetime)<'01/01/1992'                                                              --OCL REQUEST                                            
UPDATE tblStation SET Ship='RU9H' WHERE Ship='SMOLENSK' AND cast([Date] as datetime)>='01/01/1992'                                                                       --Call sign UFJJ  AS OF 1/1/1992 (290903 ICES added)
UPDATE tblStation SET Ship='06ME' WHERE Ship='METEOR' AND cast([Date] as datetime)<'01/01/1992'                                                                 --PRE-7/64                                               
UPDATE tblStation SET Ship='06MT' WHERE Ship='METEOR' AND cast([Date] as datetime)>='01/01/1992'                                                                                                                                 
UPDATE tblStation SET Ship='90P5' WHERE Ship='PROF.MARTI' AND cast([Date] as datetime)<'01/01/1992'                     UTTQ                                                                          --PRE-7/64                                               
UPDATE tblStation SET Ship='RUP5' WHERE Ship='PROF.MARTI' AND cast([Date] as datetime)>='01/01/1992'                              (UTTQ) AS OF 1/1/1992                                                                                                                
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      
                                                      