Combine two different types of column

[acnovice]

Hi,

I want to combine two different types of columns into one. QNo is a numerical, QNo Rev is a char type. The columns are like following.

QNo. QNo Rev.
1000
1000 A
1000 B

After combining, sorting is

1000
1000A
1000B

Any help will be appreciated.

 

[PHV]

Expr1: QNo & [QNo Rev]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[acnovice]

PHV,

I appreciate your response but have one more question.
When I sorted QNos by DESC after combine, the result is like following.

999
998
998A
1000
100
10
1

I want this order.

1000
1000A
999
998
998A
....
100
10
1

Thank you.

 

[PHV]

ORDER BY Val(QNos) DESC, QNos ASC

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[acnovice]

PHV,

I tried what you post but it didn't work.
It said "type mismatch...".

I just put

ORDER BY QNos DESC;

and it works fine.

Thank you for the post.