escape in sql

Amused Antelope answered on March 27, 2020 Popularity 10/10 Helpfulness 4/10

answer escape in sql

related sql escape quote

related escape-character-in-sql-server

Comment

SELECT columns FROM table
WHERE column LIKE '%\%%' ESCAPE '\'

Popularity 10/10 Helpfulness 4/10 Language sql

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jan 02 2023

Amused Antelope

0 Answers Avg Quality 2/10

Closely Related Answers

Comment

DECLARE @my_table TABLE (
    [value] VARCHAR(200)
)

INSERT INTO @my_table VALUES ('hi, my name''s tim.')

SELECT * FROM @my_table

Popularity 10/10 Helpfulness 4/10 Language sql

Tags: quote quot

Link to this answer
Share Copy Link

Contributed on Mar 27 2020

Gorgeous Gentoo

0 Answers Avg Quality 2/10

Comment

To escape the character in SQL SERVER just put the single quotes
infront of the one that you're trying to escape.

e.g select 'it''s escaped'

Popularity 10/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Mar 26 2021

Fortune Mbulazi

0 Answers Avg Quality 2/10