Teiid does not recognize "CONVERT"

[cristopher.torres]

Hi, I have a problem when using "CONVERT":

CONVERT (INT, FIELD) for some reason teiid does not recognize the sentence

[cristopher.torres]

What happens is that I have a varchar field: '00040' and another '40' and I need to match

[shawkins]

The convert function in Teiid is similar to a cast.  The form is CONVERT(val, type), for example CONVERT('1', integer)

Which database's CONVERT function are you expecting?

[cristopher.torres]

I have already tried using the CONVERT function, even the way you have explained me; What happens is that it does not recognize CONVERT as a function, I would like to know if it is necessary to import a library or something to the teiid so that it can recognize it.

[cristopher.torres]

The designer has an indicator when it recognizes a function and is that the command is placed in blue color, in this case CONVERT remains standard, but INT if it recognizes it as such.

[shawkins]

The runtime recognizes the usage of CONVERT(val, type) - there is no additional library or settings needed.

If you are having an issue in Designer, it may help to have a screen cap of the problem.

[cristopher.torres]

Sorry, you were right I was using INT instead of INTEGER. But also, I have a problem with the OUTER function, how would the syntax in teiid?

[shawkins]

Teiid does not have a built-in OUTER function.  Which database's OUTER function are you wanting support for?