Yes, if the retainer agreement provides for that and the attorney agrees. However, depending on the type of matter (for instance criminal matters), it may be difficult for the attorney to withdraw without the court's approval and so there may have to be some steps taken so that a motion to a consent to change of attorneys to you going it alone after the hearing can be made, or the attorney can make it clear to the forum or other parties that he's appearing for you on a one shot basis.
Some attorneys may be reluctant to go represent you on this basis, or get into the matter without doing some "due diligence" that their representations on your behalf do not violate ethical or court rules (i.e., aren't frivolous, or without basis or intended simply to delay, harass or annoy the Court or other parties).
But, yes, especially in these days of widespread economic hardship and distress in the practice of law as well as many other businesses, you should be able to find an attorney who is willing to do "limited scope representation" so long as the terms are defined and transparent to you and him/her, the other parties and the forum (which might, however, affect your negotiating position if other people know the attorney is not going to be involved beyond this one hearing).
This answer is provided under the Avvo.com “Terms and Conditions of Use” (“ToU”), particularly ¶9 which states that any information provided is not intended as legal advice or to create an attorney-client relationship between you and me or any other attorney. Such information is intended for general informational purposes only and should be used only as a starting point for addressing your legal issues. In particular, my answers and those of others are not a substitute for an in-person or telephone consultation with an attorney licensed to practice in your jurisdiction about your specific legal issue, and you should not rely solely upon Legal Information you obtain from this website or other resources which may be linked to an answer for informational purposes. You understand that questions and answers or other postings to the Site are not confidential and are not subject to attorney-client privilege. The full Avvo ToU are set forth at http://www.avvo.com/support/terms . In addition, while similar legal principles often apply in many states, I am only licensed to practice in the State of New York and Federal Courts. Any general information I provide about non-New York laws should be checked with an attorney licensed to practice in your State. Lastly, New York State Court rules (22 NYCRR Part 1200, Rule 7.1) also require me to inform you that my answers and attorney profile posted on the Avvo.com site may be considered "attorney advertising" and that "prior results do not guarantee a similar outcome".
The only thing that I would add to previous counsel's excellent answer is that some judges do not tend to like limited notices of appearance, and sometimes will file them as regular notices of appearance. Making sure that the lawyer you hire is knowledgeable of the courts in your area is especially important for a limited appearance.
This posting is for informational purposes only. Answering this question does not constitute forming a lawyer/client relationship. For more complete advice, specialized to your situation and locality, consult a lawyer from that state.
I am sure there are attorneys who would contract to do one hearing. The Court would have to be informed the attorney is withdrawling his appearance after the hearing.
Jonathan N. Portner, Esquire, Portner & Shure, P.A. Maryland and Virginia Personal Injury Attorneys. This response is general information and not legal advice, and does not create an attorney-client relationship. This response should not be relied upon. Please note that no attorney-client relationship exists between the sender and the recipient of this message in the absence of either (1) a signed fee contract and (2) remission of an agreed-upon retainer. Absent such an agreement and retainer, I am not engaged by you as an attorney, nor is any other member of my law firm