user: ### NOW ANSWER:
Question: which regiment was in the Fulton County
Columns: ['Division', 'Brigade', 'Regiment', 'Colonel', 'County']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['1st Division', '1st Brigade', '47th Regiment', 'Col.', 'Hot Spring']
SQL:

assistant: SELECT "Regiment" FROM "Table" WHERE "County" = 'Fulton';