Untitled

mail@pastecode.io avatar
unknown
plain_text
2 months ago
386 B
1
Indexable
Never
select ElectronicAddress,ElectronicAddress.HeaderRID, case 
    when  (cast(ElectronicAddress as varchar(32)) collate SQL_Latin1_General_Cp1251_CS_AS) = ElectronicAddress AND ElectronicAddress LIKE '%[a-zA-Z0-9]%' AND TRIM(ElectronicAddress) NOT LIKE '%[^a-zA-Z0-9@._-]%'
    then 0 
    else 1 
end MaSpecZnaky from ElectronicAddress where ElectronicAddress.ElectronicAddressTypeId = 2
Leave a Comment