Thanks Thom A!

Hi Phil,

I would like to create the same script without using a UNION, but I'm not sure how to do that.

It works great, thanks Phil.

Thanks Phil, It works perfectly except that sometimes there are multiple SalesIds where IsOwner = 1, but I want only unique values within the duplicate SalesAmounts. See the example below.

SalesId...

This is perfect, thank!

Thank you - it's good to know others have tried and succeeded. I am hoping the Attunity Oracle components work well

Hope you get it working

Thank you both for your help!

This is the code I am trying to run. I need the code to run the code against the database name I assign...

Hi Chris,

thanks you save the day, can the allowed values be stored in the function instead to make it a Scalar Function instead?

Thanks,

Hi ChrisM,

Your solution is perfect but it changes the case from lower / title to upper case can this be corrected to keep the original case?

Thanks

Thanks, will try out later on tonight.

Have a great night.

Thanks,

how do you call the function in a select?

Hi Lowell,

Thank you for the help but the requirements need the characters to be invalidated against a table containing characters allowed and characters that are not contained within the table...

Hi Sean,

I try the sql script but it was producing 6 rows of data instead of 3, please see the attached picture.

thanks for helping out.

Thank you it works perfectly!!