In BigQuery there is no LEFT() or RIGHT() functions, You can use substr() instead : To get the left 4 characters: copy select substr('copycoding',1,4) ...
確定! 回上一頁