S
Saber Soleymani
Hello,
I've a table like this:
ID - PartNo
-------------
1 a
2 b
3 c
4 d
I pass a query to access (through ASP.Net) like this:
SELECT *
FROM tbl
Where PartNo In
('d','a','c')
The result is:
a
c
d
records.
but I expect this order:
d
a
c
How can I customize order query?
Something like this imaginary query:
Select * From tbl Where PartNo In ('d','a','c') Order By
PartNo('d',;a','c')!!!
I've a table like this:
ID - PartNo
-------------
1 a
2 b
3 c
4 d
I pass a query to access (through ASP.Net) like this:
SELECT *
FROM tbl
Where PartNo In
('d','a','c')
The result is:
a
c
d
records.
but I expect this order:
d
a
c
How can I customize order query?
Something like this imaginary query:
Select * From tbl Where PartNo In ('d','a','c') Order By
PartNo('d',;a','c')!!!