where in 用法，请问

where in 用法，请教！
如果feebuySp不为空时，这样没问题，如果feebuySp为空时，我想得到全部记录，应该怎么改一下？
string feebuySp="'"+feebuyerbhFX.Text.Replace(",","','")+"'";

select * from feelist where feebuyerSp in("+feebuySp+")

[解决办法]

SQL code

select * from feelist where feebuyerSp in("+feebuySp+") and feebuyerSp is not null
[解决办法]
string sql = "";
if(feebuySp == "")
{
  sql = select * from feelist }
else
{
  sql = select * from feelist where feebuyerSp in("+feebuySp+")
}

[解决办法]
SQL code
select * from feelist where feebuyerSp is null or feebuyerSp ='' or feebuyerSp  like '%'+feebuySp+'%')
[解决办法]
SQL code
if isnull(feebuySp,'')=''select * from feelist
[解决办法]
SQL code
select * from feelist where feebuyerSp in("+feebuySp+") or feebuyerSp !=""
[解决办法]
SQL code
string sql = "select * from feelist";if(feebuyerbhFX.Text.Trim().Length){  string feebuySp="'"+feebuyerbhFX.Text.Replace(",","','")+"'";   sql += " where feebuyerSp in("+feebuySp+")";}
[解决办法]
如果feebuySp<>null then  
select * from feelist where feebuyerSp in("+feebuySp+")
否则 select * from feelist
[解决办法]
引用楼主 liuvb 的帖子:

如果feebuySp不为空时，这样没问题，如果feebuySp为空时，我想得到全部记录，应该怎么改一下？ 
string feebuySp="'"+feebuyerbhFX.Text.Replace(",","','")+"'"; 

select * from feelist where feebuyerSp in("+feebuySp+")

[解决办法]
C# code
 string feebuySp = "'" + feebuyerbhFX.Text.Replace(",", "','") + "'";        string sql = "select * from feelist where feebuyerSp in ('"+feebuySp+"')";
[解决办法]
SQL code
select * from feelist where feebuyerSp is null
[解决办法]
在程序中加个判断，分别用不同的SQL
if(feebuySp==null)
{
  select * from feelist
}
else
{
  select * from feelist where feebuyerSp in("+feebuySp+")
}
[解决办法]
引用楼主 liuvb 的帖子:

如果feebuySp不为空时，这样没问题，如果feebuySp为空时，我想得到全部记录，应该怎么改一下？ 
string feebuySp="'"+feebuyerbhFX.Text.Replace(",","','")+"'"; 

select * from feelist where feebuyerSp in("+feebuySp+")

[解决办法]
探讨

引用楼主 liuvb 的帖子:
SQL codeselect * from feelist where feebuyerSp is null or feebuyerSp in("+feebuySp+")

------解决方案-------------------- 
 
或通过存储过程执行
select * from feelist where (feebuyerSp in("+feebuySp+")  or feebuyerSp  is null)


[解决办法]
另外写一个函数，判断是否为空

'如果数据的字符为NULL，这是要特别处理才能显示
Function NullCode(zdm) As String
   If IsNull(zdm) = True Then
       NullCode = ""
   Else
       NullCode = zdm
   End If
End Function



主函数里面加上

ssssss = nullcode(rs!**)
[解决办法]
探讨

引用:
引用: 
引用楼主 liuvb 的帖子: 
SQL codeselect * from feelist where feebuyerSp is null or feebuyerSp in("+feebuySp+") 

同意 
 

这样还是不行啊

[解决办法]
顶一下。。。
[解决办法]
select * from feelist where feebuyerSp is null or feebuyerSp in("+feebuySp+")