Hi Perry & John,
Thanks for your help so far. I've been trying using CONVERT but can't get it working right. Maybe you can help with my syntax?
? SQLEXEC(mnConnection,'SELECT CONVERT(char(18),Proj.PROJ_ID) AS Proj_ID, Proj.L5_PROJ_SEG_ID, Proj.L5_PROJ_NAME, Proj.ORG_ID,;
Proj.PROJ_TYPE_DC;
FROM ZAKI.PROJ Proj;
ORDER BY Proj.PROJ_ID')
The above SQL-SELECT works.
? SQLEXEC(mnConnection,'SELECT Proj.PROJ_ID, Proj.L5_PROJ_SEG_ID, Proj.L5_PROJ_NAME, Proj.ORG_ID,;
Proj.PROJ_TYPE_DC;
FROM ZAKI.PROJ Proj;
WHERE {fn CONVERT(char(18),Proj.PROJ_ID)} IN (?mclevel4);
ORDER BY Proj.PROJ_ID')
The above SQL-SELECT with the CONVERT in the WHERE clause always returns "Syntax error or sharing violation"
According to the samples in help, CONVERT can be used in the WHERE clause. Can you tell what I'm doing wrong? TIA
>All of the SQL work I've done so far is thru SPT. It just offers more control and you can see exactly what's going on. I haven't run into your exact problem yet.
>
>PF
>
>
>>Thanks for the info Perry. I'll look into the SQL Books Online.
>>
>>In the View Designer, CONVERT isn't an available function. Can I just type it in the function window manually or is this one of those things that can only be handled using SQL Passthrough?
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.