I am looking to remove some string characters in an output that I have so that it only shows numbers rather then letters and numbers. My Query is:
Select DISTINCT t.processed 'Title',
(Select max(reconst) from isbn where bib# = t.bib#) 'ISBN',
t.bib# 'Bib#',
(select max(collection) from item where bib#=t.bib#) 'Collection',
convert ( varchar(3), (Select count (*) from item i where i.bib# = t.bib#)) 'Total Items',
(Select count (*) from item i where i.bib# = t.bib# and item_status not in ('o','l','cr','m')) 'Eligible Items',
(Select count(*) from request r where r.bib# = t.bib#) 'Requests'
from title t
inner join isbn
on t.bib#=isbn.bib#
inner join item
on t.bib#=item.bib#
where t.bib# in (Select bib# from request)
and convert( int, (Select count(*) from item i where i.bib# = t.bib#)) <
convert( int, (Select count(*) from request r where r.bib# = t.bib#))
order by Requests desc
The desired output is in the ISBN
column which would would look like 9781501132957
, which would be removing the letters C
and also the words such as hardcover
, HRD1
, acid-free paper
, softcover
,PAP
, DVD
, CD
, pbk
and special characters such as ()
, :
, .
, -
Thank you in advance