|
Klassiske filtyper er ikke lenger tilgjengelige for bruk fra og med januar 2021. Du kan overføre klassiske filer eller laste ned en PDF-fil. Finn ut mer

Error cannot cast to int "000OCI"

Besvart
Be om demo

Hi, 

In one of my queries on Wdata I am getting the error (cannot cast to INT"000OCI") that is understandable since can't cast character to INT. However the field where I am using the cast function does not have any record that contains such a value. 

Any advice or hint will be appreciated. Thank you in advance

1

Kommentarer

1 kommentar

Dato Stemmer
  • Isaac Oard

    Fathi Bousalama
    I would double check that field just in case. I would create a new query with just that field and select "Show only distinct rows" and check what is in that column

    0

Logg på for å legge inn en kommentar.