How to convert identifier to integer in sql?

Hello All,

How to convert identifier to integer in sql?

Any pointer would help.

Thanks in advance 

-Prajakta

Hi Prajakta,

Is the identifier an integer as well? You shouldn't need any explicit conversions if both fields have the same type.

 Can you give us a little more context about what you're trying to implement?

Solution

Hi Prajakta,

Is the integer an input parameter to your SQL?

In that case, define an input parameter on the SQL widget of data type integer and pass in IdentifierToInteger(YourIdParameter).

Regards,

Daniel

Solution

Hi Prajakta,

Use the integer as an input parameter , then assign it's value using IdentifierToInteger conversion method.

Afonso Carvalho wrote:

Hi Prajakta,

Is the identifier an integer as well? You shouldn't need any explicit conversions if both fields have the same type.

 Can you give us a little more context about what you're trying to implement?

Yes you are right, it was join issue. Thanks 


Daniël Kuhlmann wrote:

Hi Prajakta,

Is the integer an input parameter to your SQL?

In that case, define an input parameter on the SQL widget of data type integer and pass in IdentifierToInteger(YourIdParameter).

Regards,

Daniel


Thanks , for conversion your solution will work