SQL Server query syntax with single quote -


i have in database kia car model cee'd.

how write right syntax car model = cee'd

now using semipart of model

select make, model  cars  model '%cee%' 

but need full model name.

how write right syntax in case?

you can escape single quote (') single quote - 2 in total (''). note not double quote character ("), single character, two single quote characters (' , '):

select make,model cars model = 'cee''d' 

Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

firemonkey - How do I make a beep sound in Android using Delphi and the API? -