Tricky SQL questions on Strings | Like Operator | Substring Function | CHARINDEX | IQBees
Hello Friends,
Most commonly asked question is about Strings in SQL ( Like Operator, Substring , CharIndex ). I think most of the people knows about these. But this question is quite tricky ..if we are good at basics we will be able to crack.
Question : Write a SQL query to find the Name where Second position of the character should be an vowel (a,e,i,o,u ) ?
Ans: SELECT * FROM EmployeeData
WHERE Name LIKE '_[aeiou]%';
You can also achieve the same by substring, charindex. Use substring in case of multiple words search
LIKE operator is used in a WHERE clause to search for a specified pattern in a column
CHARINDEX function searches for a substring in a string, and returns the position. If the substring is not found, this function returns 0.
substring :Required. The substring to search for
string: Required. The string to be searched
start: Optional. The position where the search will start (if you do not want to start at the beginning of string). The first position in string is 1
Syntax
CHARINDEX(substring, string, start)
Substring : Function extracts some characters from a string.
Syntax : SUBSTRING(string, start, length)
string Required. The string to extract from
start Required. The start position. The first position in string is 1
length Required. The number of characters to extract. Must be a positive number
If you need personal help in SQL, Mock interviews, You can contact me
Regards,
IQBees
Tricky SQL questions on Strings | Like Operator | Substring Function | CHARINDEX | IQBees
#SQL #SQLQuery #SQLInterviewQuestion
sql interview questions,sql faq,sql interview questions and answers,IQBees,Tricky SQL questions on Strings,Like Operator,Substring function,CHARINDEX,substring syntax,substring interview questions,sql query,sql tutorial,interview questions sql,tricky interview questions sql strings,top sql interview questions, like operator in sql server, pattern matching