Can I convert line4 to a number within the view itself? It is string data to begin with.
REATE VIEW dbo.extradata_AC
AS
SELECT TOP 100 PERCENT number, line1, line2, line3, line4, line5
FROM dbo.extradata
WHERE (extracode = 'AC')
ORDER BY number
Thanks in advance.
REATE VIEW dbo.extradata_AC
AS
SELECT TOP 100 PERCENT number, line1, line2, line3, line4, line5
FROM dbo.extradata
WHERE (extracode = 'AC')
ORDER BY number
Thanks in advance.