Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: StephenLeach
- Content: Threads
- Order by date
-
LIKE operator
In a SELECT statement I have a condition along the lines of columnName LIKE '%'. I have noticed that this gives different results to '%' LIKE columnName. Why is this? I would have thought that the LIKE operator would behave as the = operator, as in a=b is equivalent to saying b=a. Does anyone...- StephenLeach
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
IF statements and CREATE TABLE statements
I have an IF statement whereby a tempory table is created by a SELECT INTO command. If the IF statement evaluates to true then the data for the temporary table comes from one source and if the IF statement is FALSE then the data comes from a second source. The name of the temporary table is the...- StephenLeach
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
