alias-column

SQL: inner join on alias column

Hi all, Previously I have asked to strip text from a field and convert it to an int, this works successfully. But now I would like to do an INNER JOIN on this new value. So I have this: SELECT CONVERT(int, SUBSTRING(accountingTab.id, PATINDEX('%[0-9]%', accountingTab.id), 999)) AS 'memId', userDetails.title, userDetails.lname FROM ...

LINQ to SQL and Column Alias with spaces

Still a bit new to Linq. This is driving me nuts. I want to alias a column, the alias should have a space. This works fine: Dim q = From tmp in t.Table Select iDate = tmp.iDate But, I want this to work Dim q = From tmp in t.Table Select "Some Alias With Space" = tmp.iDate Any ideas? ...