Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Extracting First 2 digit

Hi 

I have a column with 3 digit number value that i like to extract the first 2 digit to a new column, what query should i use?

Thanks! 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi! I think just using "left" would solve your problem

    Left("table", "numberofdigits")