Just use this
Select regno from member_master where parentregnoM=2 and parentPosM=1 and (registerAS != 'Free')
or
Select regno from member_master where parentregnoM=2 and parentPosM=1 and (registerAS <> 'Free')
Use () for your query... != , <> both are same...
Accept The Solution if you find it works for you so that it helps others also...
Thanks
Developers Blog[
^]
Hemant Singh Rautela