What is the wildcard character in SQL?
Let’s say you want to query database with LIKE for all employees whose name starts with La. The wildcard character is %, the proper query with LIKE would involve ‘La%’
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
How can I show HTML examples without them being interpreted as part of my document? 01.12.08
Within the HTML example, first replace the "&" character with "&" everywhere it occurs. Then replace the "<" character with "" in the same way. Note tha...What is contained in HTML markup? 01.12.08
It consists of : 1. Character-based data types 2. Several key components, including elements (and their attributes) 3. Character references and entity refere...What is contained in HTML markup? 11.11.08
It consists of : 1. Character-based data types 2. Several key components, including elements (and their attributes) 3. Character references and entity refere...How do I extract a substring from a string? 31.10.08
To extract a substring from a string, use the substring method: string.substring(start,end) Here string - is the string from which you want to extract a...What is ‘LIKE’ used for in WHERE clause? What are the wildcard characters ? 28.07.08
LIKE is used for partial string matches. '%' ( for a string of any character ) and '_' (for any single character ) are the two wild card characters....What keyword does an SQL SELECT statement use for a string search ? 02.04.08
The LIKE keyword allows for string searches. The % sign is used as a wildcard....which characters may be used as the second character of an identifier, but not as the first character of an identifier? 19.05.07
The digits 0 through 9 may not be used as the first character of an identifier but they may be used after the first character of an identifier....What is the wildcard character in SQL? 04.07.06
Let’s say you want to query database with LIKE for all employees whose name starts with La. The wildcard character is %, the proper query with LIKE would invo...What is an HTML “entity”? 29.03.06
An entity is a specific character string that has the effect of causing a formatting program to select and present a particular character or notation....Why doesn’t the following statement work? 12.03.06
char str[ ] = "Hello" ; strcat ( str, '!' ) ; Ans: The string function strcat( ) concatenates strings and not a character. The basic difference between a stri...