[Request] SQL syntax

[SkuulCandy]

Hi, anyone have this sql syntax :

UPDATE PS_GameData.dbo.CharItems SET CraftName = Craftname + '" & TextStat.Text & "' WHERE  (CharID,ItemID) value ('" & TextCharID.Text & "','" & TextItemID.Text & "')

I would like this :
When i click on my button named 'STR' this query will be executed into my db.
Example if i right '50' into TextStat.Text when i click on 'STR' button Craftname of ItemID = TextItemID.Text where CharID= TextCharID.text will be updated. SO it's doesn't work because craftname doesn't work like that. And anyone have this party of my sql syntaxe can be work :

SET CraftName = Craftname + '" & TextStat.Text & "'

Thanks

[nubness]

-- UPDATE STR
UPDATE CharItems
SET Craftname = @STR + SUBSTRING(Craftname, 3, 18)
WHERE ItemUID = @ItemUID

-- UPDATE DEX
UPDATE CharItems
SET Craftname = SUBSTRING(Craftname, 1, 2) + @DEX + SUBSTRING(Craftname, 5, 16)
WHERE ItemUID = @ItemUID

-- UPDATE REC
UPDATE CharItems
SET Craftname = SUBSTRING(Craftname, 1, 4) + @REC + SUBSTRING(Craftname, 7, 14)
WHERE ItemUID = @ItemUID

[SkuulCandy]

Since 2013 my Shaiya Developper not Vb net.