Creating Views

[t16turbo]

hi,

I have created a view in an Oracel database using this code:
CREATE VIEW PDSStuff AS
SELECT o.dsti_proj_ref, o.ID, s.UNIQUE_NAME, substr(dsti_proj_ref,1,6)||'-'||substr(dsti_proj_ref,8,1) As PDSCode
FROM odf_ca_project o, srm_projects s
WHERE o.id = s.id AND o.dsti_proj_ref Like 'D0%'


when I try to run this code on my Sybase database via MSQuery, it complains that SUBSTR is not a built in function name. How can Ido this in Sybase?

 

[tinkuK]

Hi
We have substring(expression/string,start,length) function in sybase to do the same