A fellow on the CR forum has the following problem:
snip..
Part numbers have a revision letter as follows:
123A-234A
123A-234B
123A-234C I want to show this one only
I posted this SQL statement which works but returns two columns. How can I rejoin the columns?? This puzles me
Thanks MikeD
Select left(p2.pn,8) as pn ,Max(right(p2.pn,1))as Rev
From fd_pn p2
Group by left(p2.pn,8)
Mike Davis
MSsql, VB and Crystal Reports Developer
snip..
Part numbers have a revision letter as follows:
123A-234A
123A-234B
123A-234C I want to show this one only
I posted this SQL statement which works but returns two columns. How can I rejoin the columns?? This puzles me
Thanks MikeD
Select left(p2.pn,8) as pn ,Max(right(p2.pn,1))as Rev
From fd_pn p2
Group by left(p2.pn,8)
Mike Davis
MSsql, VB and Crystal Reports Developer