I have multi language website and would like to get the sql query result from the table based on the language select for the current page
my SQL query as follow :
FROM [Ref_LookUpValues] where Language=[LOCALE,System];
however it didn't give any result as the query doesn't parse the [LOCALE,System] variable
any suggestion ?