On Thu, Oct 15, 2015 at 3:15 PM, Ramesh T <[email protected]>
wrote:
> yes David gave correct solution
>
> but , the value I'm using and it's column in the table sometimes value
> may be '123-987-123' or '123-987-123-13-87'
>
>
So adapt the answer provided to match your data.
if pass like below must return else condiion 0,
>
> select case when select split_part('123-987-123','-',4) >0
> then 1 else 0 end
> it's return error like integer need...
>
>
I have no clue what you are trying to say here...
David J.
