SELECT * FROM studentrecords where [student id]='1234' doesnt returning the first row in mssql
Post by:amrish sharma
where 1234 is under [student id]
Post by:Peter Johnson
Is studentid a character column or a numeric column? If numeric, does it work if you remove the quotes? Are you sure there is a studentrecord with that studentid? Are you getting an error, or just no rows selected?