Skemcin

I am wondering, is there a way to write a SQL statement that will return the records on either side of a single record.For instance, if I have(select) record B in a table, can I write one expression that will return A,B,C - my input being 'B'? I know I could do this with three statements, one for B, one to get the TOP 1 record for anything less than B, and one to get the TOP 1 record for anything greater than B - is there a way to combine this logic - without a stored procedure?Thanks in advance.

Hi,I've used this site for years and absolutely love it. Its biggest help to me came when I used it to introduce me to XML and now its helpful to help me double check my syntax with SQL. I mention this mainly since this is my first post and just wanted to pay that testiment.My question is, why is there no Cold Fusion tutorial? Is it mainly because you would have to have this site running with Cold Fusion to be consistant with all the other tutorials?If that is the main reason, would you consider the example popups to be run on a remote server (for example, maybe mine?). Do you also need an author to create the same ASP or PHP tutorial in Cold Fusion?Any feedback is appreciate. Keep up the excellent work on maintaining the site.