I am facing issue while using like operator with regex expression.
Below is the sample SQL script
create table #Temp (displayname varchar(100) )
insert into #Temp values('SG_UNFE_01_VIPCP30DY')
select * from #Temp where displayname like '%^[A-Z][A-Z]_[A-Z][A-Z]FE_[0-9][0-9]_VIP.*%'
drop table #Temp
Please help, Thanks in advance.