CAST(something AS something)

Posts   
 
    
mattlant
User
Posts: 16
Joined: 24-Jun-2005
# Posted on: 24-Jun-2005 18:15:50   

Is there anyway to use this in an expression. I am creating a dynamic list and one of the fields is a concatentate of a string and an int.

the query would look something like this:

SELECT Name + ' ' + CAST(Round AS varchar(10)) AS RoundName

I finally figured out how to do concatenates but now I am stumped again on this one.

Thx again

Matt

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 24-Jun-2005 18:25:26   

Casts are not supported as they're considered a GUI specific feature. They're planned for a future version.

Frans Bouma | Lead developer LLBLGen Pro