I've only done some simple stuff with Convert to get the dates right.
Whats the "fn" in the where clause for?
PF
>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?
(On an infant's shirt): Already smarter than Bush