Hello, I have created a custom query,but it did't works.Can you help me
SEL ECT
CatalogCashiers.LastName,
CatalogCashiers.FirstName,
CASE
WHEN CatalogCashiers.Gender = "Female"
THEN "Mrs. ," + SUBSTRING(CatalogCashiers.LastName, 1, 1) + "," +
SUBSTRING(CatalogCashiers.FirstName, 1, 1)
WHEN CatalogCashiers.Gender = "Male"
THEN
"Mr. ," + SUBSTRING(CatalogCashiers.LastName, 1, 1) + "," +
SUBSTRING(CatalogCashiers.FirstName, 1, 1)
ELSE
SUBSTRING(CatalogCashiers.LastName, 1, 1) + "," +
SUBSTRING(CatalogCashiers.FirstName, 1, 1)
END
FR OM
Catalog.Cashiers AS CatalogCashiers
For students who study 1C Junior course.