Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Databases Programming Interviews:BtrieveClipperData ModelingData StructuresDatabase AdministrationDatabase Administrator (DBA)Database AnalystDatabase DeveloperDB DevelopmentEDI/Data Integration ExpertFirebirdHierarchicalIBM DB2InformixJava DatabaseMariaDBMicrosoft Access DeveloperMongoDBMS SQL ServerMySQL ProgrammingNetworkNoSQLObject RelationalPostgrePostgreSQLProgressRDBMSRelationalSQLSQL AdministratorSQL and PL/SQLSQL Notification ServicesSQL server 2008SSRSStored ProcedureSybaseTeradata
Copyright © 2018. All Rights Reserved
MS SQL Server Interview Question:
How To Use Wildcard Characters in LIKE Operations in MS SQL Server?
Submitted by: AdministratorWildcard character '%' can be used in the pattern string for the LIKE operator to match any string of zero or more characters. The following example uses '%Sport% Store' to search all company names that has a partial word 'Sport' and ended with the word 'Store'. The sample database AdventureWorksLT provided by Microsoft is used.
USE adventureWorksLT
GO
SELECT c.CompanyName FROM SalesLT.Customer c
WHERE c.CompanyName LIKE '%Sport% Store'
GO
CompanyName
-------------------------
Specialty Sports Store
Camping and Sports Store
Vigorous Sports Store
Our Sporting Goods Store
Sports Store
Sports Products Store
Submitted by: Administrator
USE adventureWorksLT
GO
SELECT c.CompanyName FROM SalesLT.Customer c
WHERE c.CompanyName LIKE '%Sport% Store'
GO
CompanyName
-------------------------
Specialty Sports Store
Camping and Sports Store
Vigorous Sports Store
Our Sporting Goods Store
Sports Store
Sports Products Store
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.