hi hope this helps

SAMPLE DATA

DROP TABLE IF EXISTS dbo.SampleData;

GO

CREATE TABLE dbo.SampleData

(

Col1 VARCHAR(20)

);

GO

INSERT INTO dbo.SampleData (Col1)

VALUES

('A'),

('B'),

('A10'),

('A20'),

('B05'),

('A10Q'),

('A30P'),

('B05X'),

('A10QA'),

('B05XY'),

('A10QA01'),

('A10QA02'),

('B05XY99'),

('C'),

('C03'),

('C03C'),

('C03CA'),

('C03CA01'),

('D07'),

('D07M'),

('E99ZZ01');

GO

T-SQL solution

SELECT

   Col1,

      CASE WHEN LEN(Col1) >= 1 THEN LEFT(Col1,1) END AS Level1,...

hi

hope this helps

DROP TABLE IF EXISTS SampleData;

CREATE TABLE SampleData

(

col1 VARCHAR(max)

);

INSERT INTO SampleData (col1)

select 'NYSTATIN SUSP 500000 UNIT = 5 ML (1 5 ML CUP)'

UNION ALL

Select 'NYSTATIN SUSP 0.75 UNIT =...

hi

hope this helps

DROP TABLE IF EXISTS SampleData;

CREATE TABLE SampleData

(

col1 NVARCHAR(max)

);

INSERT INTO SampleData (col1)

select 'Sarat'

union ALL

select 'qwerty'

union ALL

select 'AS123werTy'

t-sql solution

select

col1

,case when

col1 COLLATE Latin1_General_CS_AS <> lower(col1 COLLATE Latin1_General_CS_AS) then...

hi hope this helps

CREATE TABLE locations (

id INT PRIMARY KEY IDENTITY(1,1),

latitude FLOAT NOT NULL,

longitude FLOAT NOT NULL

);

INSERT INTO locations (latitude, longitude)

VALUES

(45.123456, -111.123456), -- Center point

(45.200000, -111.200000), -- Nearby

(45.500000, -111.500000), --...

• This reply was modified 3 months, 1 weeks ago by naumon765.
• This reply was modified 3 months, 1 weeks ago by naumon765.