> Is it possible?
>
> I'm putting this into 1 lookup:
>
> INSERT INTO tblOrganization (iOrganizationId,sIntegrationCode,
> iOrganizationTypeId,sName,sNameLegal,sCustomFieldString1,
> srtCustomFieldSmallInt1,sABCLicense,sPhone,iOrganizationStatusId)
> values (
> ?,
> dbo.padstring(?,6),
> ?,
> dbo.initcap(?),
> dbo.initcap(?),
> ?,
> dbo.convertCharToNum(?),
> dbo.padstring(?,12),
> ?,
> ?)
> which crashes the Enterprise Manager every time I try to run it.
> After removing it to no funcitons and just straight ?s it all ran
> fine. It doesn't even mind the function that has a single ?. Where
> it freaks out and crashes is if i put in even a single one of the
> functions that pass the ? and a constant. Is it possible to call
> those from within a lookup (do I just need to up the sevice pack or
> something) or am I pretty much dead in the water here? ::all on SQL
> Server 2000::
>