I have a text edit PRODUCT that looks like this: 'ADHESIVE 478', with apostrophes. How do I make it look like this: 478 ADHESION on sql server? I've tried it that way and it does not work:
DECLARE @ProdutoNome VARCHAR(30);
SET @ProdutoNome = REPLACE(''ADESIVO 478'', '''', '')
PRINT @ProdutoNome