Free for PREMIUM members
Learn how to a build a cloud-first strategyRegister Now
WHERE NOT (
rcd LIKE '*%'
OR rcd IS NULL
OR rcd = 'n'
Open in new window
CREATE TABLE #tmp (val varchar(10))
INSERT INTO #tmp (val) VALUES ('*abc'), ('123'), ('Bob'), ('wackadoo')
SELECT * FROM #tmp WHERE val NOT LIKE '*%'
SELECT * FROM #tmp WHERE LEFT(val, 1) <> '*'
Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.