DECLARE @VariableDate DATE

SELECT @VariableDate = '4-APR-2008'

SELECT cast('100' as int) - convert(int,10.50)



select substring ('hello world',7,5)

select substring ((replicate ('infy',charindex('n','infy'))),5,4)