What if you want to get all the characters before a symbol, such as the hyphen symbol? In that case, you may use: LEFT(field_name,CHARINDEX('symbol needed', ...
確定! 回上一頁