Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
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.
If you're trying to add it to your variable within your sql statement it has to be handled a little differently.
ex.
This works:
declare @name as varchar(15)
set @name = 'smit%'
select * from staff where lastname like @name
This, or any variation of this, won't work:
declare @name as varchar(15)
set @name = 'smit'
select * from staff where lastname like (@name + '%')
So with your code you can do this:
SELECT Counter, SiteRef, ccount, SiteName, AddressLine1, AddressLine2, AddressLine3, Town, Postcode
FROM SiteDetails
WHERE (Postcode = @POSTCODETOFIND ) OR (Postcode LIKE @POSTCODETOFIND )
as long as you're setting the wildcard character in your variable prior to passing it to sql.