 |  |  |  |  |  |  |  |
Allowing NULL search in SelectCommand of SQLDataSource
Please support our MS SQL advertiser: Intel Parallel Studio Home
 |
Hi,
I am trying to do a search function on my GridView. However when I tried using ( LIKE '%' + @ea_name2 + '%' ), it would only return me values if "ea_name2" is not null. I would like that SQL statement to execute even when "ea_name2" is null. Any ideas?
Thanks in advance!
I am trying to do a search function on my GridView. However when I tried using ( LIKE '%' + @ea_name2 + '%' ), it would only return me values if "ea_name2" is not null. I would like that SQL statement to execute even when "ea_name2" is null. Any ideas?
MS SQL Syntax (Toggle Plain Text)
Thanks in advance!
•
•
Join Date: Aug 2006
Posts: 2,065
Reputation: 
Solved Threads: 256
Did you try
SELECT * FROM [ea] WHERE ([ea_name] LIKE '%' + @ea_name2 + '%' or [ea_name] is null) ?? BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
|
Other Threads in the MS SQL Forum
- Previous Thread: database copying from local to server
- Next Thread: Where is AlwaysUseDefaultCodePage?
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MS SQL Posts
- Today's Posts
- Unanswered Threads
