how to convert tuple value into string

[mg24]

Hi Team,

how to convert tuple value into a string.
after running sql query I get output in tuple.

want to convert it into string.

1 2	sql_data = cursor.fetchall()[0] sql_data = ('AUS',)    # tuple value , expected only 'AUS'

Expected output

Output:
sql_string = 'AUS'

Yoriz write Oct-06-2022, 05:24 AM:
Please post all code, output and errors (in their entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.

[XavierPlatinum]

You have to convert the items in the tuple separately.

1	your_string = f"{str(your_tuple[0])} {str(your_tuple[1])}"

[DeaD_EyE]

The method fetchall returns a list with results. If there is no result, the list is empty.
For each result in the list, you have to access the field.

What you could do:

1 2	sql_data = cursor.fetchall()[0][0] # acessing the first result, then the first element of the result

If you want only one result, then use the right method.
https://docs.python.org/3/library/sqlite...r.fetchone

If fetchone returns a None, then you have no result.
If result is a tuple, then you got your result.