SELECT
a.AccountNumber, a.FirstName, a.LastName, a.Address, a.City, a.State,
a.Zip, a.EmailAddress, a.PhoneNumber, a.LastUpdated, a.LastVisit,
a.TotalSales, a.AccountOpened, a.CustomText4 as StoreCode,
CASE
WHEN (a.CustomText1 IS 'JAN') THEN '1'
END AS DOB,
GETDATE() as Extract_date
FROM
database.dbo.Customer a
CustomText1
列包含文本数据的月份数据。我正在尝试将JAN-DEC转换为数字。
CASE WHEN IS ''不起作用。
WHEN (a.CustomText1 LIKE 'JAN%') THEN '1'
- Hiten004