Thanks, that works fine, Still learning SQL

select *,

case when contractretd = 0 then '-Terms & Conditions' else '' end TC,

case when letterretd = 0 then '-Offer Leter' else '' end let,

case when scheduleretd = 0 then...

So the line would read

case when substring(claimed,1,1)= '1' then 1 end claimed

So when you enter the pararmater 2 it will then return all the 2 ...

The query worked fine until we tried to use 2a as this can occur. If the A is removed then it works?

I'm just trying to get the query to work then i will put it in an sp

This option is not in an access data project

That works thanks still getting used to sql from access

Get error

Server: Msg 170, Level 15, State 1, Line 3

Line 3: Incorrect syntax near '<'.

contracts.startdate = 01-08-04 then nextperiod = 1 form dates.period

period from dates

Sample from dates

??? what do you mean

Solved by using sproc

The hrs field is a short time field