Search:     Advanced search
Browse by category:
C/C++   |   Java   |   Oracle/Database   |   SAP   |   ASP .NET   |   Mainframe-DB2   |   Freshers
Home / Mainframe - DB2 / Q: What is 'LIKE' used for in WHERE clause? What are the wildcard characters?

Q: What is 'LIKE' used for in WHERE clause? What are the wildcard characters?
Print
Email to friend
Add comment
Views: 216
Votes: 0
Comments: 0
A: LIKE is used for partial string matches. ‘%’ ( for a string of any character ) and ‘_’ (for any single character ) are the two wild card characters. 
Others in this Category
document 1.Can you construct a tree using postorder and preorder traversal?
document How to reverse the bits in an interger?
document Q: In the WHERE clause what is BETWEEN and IN?
document What is a threaded binary tree?
document Implement Breadth First Search (BFS) and Depth First Search (DFS)
document Q: Is BETWEEN inclusive of the range values specified?
document Write a C program to count bits set in an integer?
document Q: What are the contents of a DCLGEN?
document Q: What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
document Write a C program to count bits set in an integer?
» More articles


RSS
Powered by KBPublisher (Knowledge base software)