I'll presume that you are running 1.8.1 since you didn't provide your version.If this actually a custom field or the default phone field?If memory serves me correctly, you would using the ticket number look up the internal ticket_id in ost_ticket.Then using that result look up the value in ost_form_entry_values. Something like:SELECT value FROM ost_form_entry_values WHERE entry_id = 'XXXX' AND field_id='3';note: I haven't test this.