Red Gate Sql Prompt Expand wildcard

One of the feature that I loved most from Red Gate Sql Prompt is the ability to expand wildcards on queries.

Suppose I write this little query:

1
2
3

SELECT  *
FROM    dbo.Items
WHERE   item_scan_id = 2

When I press play the query is very slow because the Item table has a column that stores large BLOB data, so I want to recover all the columns except that one that contains binary data. With Sql Prompt you can simple put the cursor after the * and press tab

And Sql Prompt will expand the query for you, now I can simply comment the image column

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11

SELECT  item_id ,
item_title ,
item_area ,
item_price ,
item_regularprice ,
item_available ,
item_scan_id ,
--item_image ,
item_imageUrl
FROM    dbo.Items
WHERE   item_scan_id = 2

This is really a cool feature I use almost every day.

alk.