I want to assign a character value to a field that contains numbers without using CAST or CONVERT so as to avoid cardinality estimate warnings

-2 votes

1 answer

54 views

I'm looking at something like

SELECT CASE WHEN MyField LIKE [0-9] THEN 'xyz'
WHEN MyField LIKE [10-99] THEN 'abc'
WHEN MyField LIKE [100-999] THEN 'def'
WHEN MyField LIKE [1000-9999] THEN 'ghi'
ELSE [pqr] END AS ACCOUNT_CATEGORY
FROM MyTable

The MyField is a datatype smallint, so does not have any numbers in it above 32,000.

Asked by Eyespi20 (1 rep)

Oct 23, 2023, 01:23 PM
Last activity: Oct 24, 2023, 12:45 AM

I want to assign a character value to a field that contains numbers without using CAST or CONVERT so as to avoid cardinality estimate warnings

Related Questions