Hi All,
I'm trying to convert this scripts into SP:
------
If Cond1 Then
phrase1 = "Where ID between 1 and 100"
Else
phrase1 = "other criteria..."
End If
If Cond2 Then
phrase2 = "criteria.."
Else
phrase2 = "other criteria..."
End If
StrSQL = "Select * from my Table " & phrase1 " & phrase 2 order by Name desc"
-------
I'm learning to use the SP and I don't the synrax to write somethign like this in SP. I want to put everything in the SP, not just the StrSQL. Can someone please help me out?
kendel
I'm trying to convert this scripts into SP:
------
If Cond1 Then
phrase1 = "Where ID between 1 and 100"
Else
phrase1 = "other criteria..."
End If
If Cond2 Then
phrase2 = "criteria.."
Else
phrase2 = "other criteria..."
End If
StrSQL = "Select * from my Table " & phrase1 " & phrase 2 order by Name desc"
-------
I'm learning to use the SP and I don't the synrax to write somethign like this in SP. I want to put everything in the SP, not just the StrSQL. Can someone please help me out?
kendel