UPDATE PART OF DATA

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » UPDATE PART OF DATA

UPDATE PART OF DATA

Rate Topic

Display Mode

Topic Options

Author

Message

Rauf Miah

Posted Sunday, March 10, 2013 7:04 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, June 04, 2013 9:57 PM
Points: 38, Visits: 69

I HAVE A TABLE WITH THREE FIELD

COMCOD SIRCODE SIRDESC
3305 180001 KARIM ENTERPRISE
3305 180002 RAHIM ENTERPRISE
3305 180003 JASON G STORE

DATE TYPES COMCOD nchar(4), SIRCODE nvarchar(6) PRIMARY KEY, SERDESC nvarchar(250).

I LIKE TO UPDATE ONLY SIRCODES TO START WITH 19 WHERE SIRCODE FROM THE LEFT STARTED WITH 18 THAT IS NEW TABLE WILL LOOK LIKE

COMCOD SIRCODE SIRDESC
3305 190001 KARIM ENTERPRISE
3305 190002 RAHIM ENTERPRISE
3305 190003 JASON G STORE

Post #1429049

Steven Willis

Posted Sunday, March 10, 2013 7:22 PM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 7:16 PM
Points: 298, Visits: 1,319


SELECT 
     COMCOD
    ,STUFF(SIRCODE,1,2,'19') AS SIRCODE
    ,SIRDESC
FROM
   [YourTable]
WHERE
   LEFT(SIRCODE,2) = '18'

Post #1429052

« Prev Topic | Next Topic »

Permissions