Like operator, include fractions in result

[Lifeseeker]

Hi there,

I have the following query, which I simplied to show only the WHERE clouse.

WHERE ((([Using our own appt date].PrblDiagCode) Like "519" Or ([Using our own appt date].PrblDiagCode)="414" Or ([Using our own appt date].PrblDiagCode)="428" Or ([Using our own appt date].PrblDiagCode)="250" Or ([Using our own appt date].PrblDiagCode)="430" Or ([Using our own appt date].PrblDiagCode)="585" Or ([Using our own appt date].PrblDiagCode)="573"));

Is there any way to also include the ones with fractions? For example, a record can be 519.3. I find that the current code doesn't give me the ones with fractions. What needs to change in the query?

Any help is much appreciated.

Thanks

 

[MarkK]

you need to use wildcards with LIKE. Try . . .

 . . . Like "519.*" . . . 
[COLOR="Green"]' or maybe[/COLOR]
 . . . Like "519.??" . . .