You may get idea from this example
DECLARE @TempTable As TABLE (Id INT,Dd VARCHAR(30))
INSERT INTO @TempTable (Id,Dd)values (1,'17/08/2014')
INSERT INTO @TempTable (Id,Dd)values (2,'18/08/2014')
INSERT INTO @TempTable (Id,Dd)values (3,'19/08/2014')
INSERT INTO @TempTable (Id,Dd)values (4,'20/08/2014')
INSERT INTO @TempTable (Id,Dd)values (5,'21/08/2014')
SELECT * FROM @TempTable WHERE CONVERT(DATE,Dd,103) BETWEEN CONVERT(DATE,'19/08/2014',103) AND CONVERT(DATE,'21/08/2014',103)