need to do in view

[leburg]

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.

 

[r937]

use CAST(line4 AS INTEGER)

and best practice says you should not have an ORDER BY clause in your view at all

(this also removes the need for the silly "TOP 100 PERCENT")

r937.com | rudy.ca

 

[leburg]

Thanks, Rudy.

Hmmm, I still a bit green, if I don't order that field, and I use it as the field I link to in Crystal, does that make a difference then?

 

[r937]

sorry, no idea what "link to in crystal" means

have you tried forum766?



r937.com | rudy.ca

 

[r937]

forum766

r937.com | rudy.ca

 

[leburg]

Thanks again, r937! I'll take advantage of that.