How do you convert a varchar into numeric?

Look up CAST and CONVERT functions in Books Online.

blindman

which books online. Cant somebody just give me an example

convert(varchar_column as numeric)

where
isnumeric(varchar_column) = 1

try this

declare @test varchar(2)
set @test = '02'
select cast(@test as numeric)

Figuring out what's meant by BOL (books online) would server you better than a simple example...

http://msdn.microsoft.com/library/de...start_4fht.asp

Give a man a fish and you feed him for a day.
Teach a man to fish (for information in books online) and you feed him
for the rest of his life (or career).

blindman

Stuff yourself:

all you can eat fish

Doesn't highlighting + Shift-F1 in QA come natural? It has been working since 6.5!!

Can't somebody press Shift-F1 for me?

No need to...never close BOL...never turn off the computer...ok once a month...

Does anyone still use CTRL-E?

I don't think it's documented..if they make me do F5 only Yukon....8-(

How about this...

..code [ENTER]
[SHIFT] Up Arrow
[CTRL]-E

Holy moly! That shift + f1 thing even works in the results pane. Now all I have to do is teach some of these college-hires how to pick what to highlight :-P

I USE CTRL+E ALL THE TIME!!! And Ctrl+Break, and Ctrl+S, and Alt+F4, and Shift+Tab, and...whatever, it's all handy.

Ok - Here you go - "My fellow nerds and I will retire to the nerdery..."

SQL Query Analyzer Keyboard Shortcuts
This table displays the keyboard shortcuts available in SQL Query Analyzer.

Activity Shortcut
Bookmarks: Clear all bookmarks. CTRL-SHIFT-F2
Bookmarks: Insert or remove a bookmark (toggle). CTRL+F2
Bookmarks: Move to next bookmark. F2
Bookmarks: Move to previous bookmark. SHIFT+F2
Cancel a query. ALT+BREAK
Connections: Connect. CTRL+O
Connections: Disconnect. CTRL+F4
Connections: Disconnect and close child window. CTRL+F4
Database object information. ALT+F1
Editing: Clear the active Editor pane. CTRL+SHIFT+DEL
Editing: Comment out code. CTRL+SHIFT+C
Editing: Copy. You can also use CTRL+INSERT. CTRL+C
Editing: Cut. You can also use SHIFT+DEL. CTRL+X
Editing: Decrease indent. SHIFT+TAB
Editing: Delete through the end of a line in the Editor pane. CTRL+DEL
Editing: Find. CTRL+F
Editing: Go to a line number. CTRL+G
Editing: Increase indent. TAB
Editing: Make selection lowercase. CTRL+SHIFT+L
Editing: Make selection uppercase. CTRL+SHIFT+U
Editing: Paste. You can also use SHIFT+INSERT. CTRL+V
Editing: Remove comments. CTRL+SHIFT+R
Editing: Repeat last search or find next. F3
Editing: Replace. CTRL+H
Editing: Select all. CTRL+A
Editing: Undo. CTRL+Z
Execute a query. You can also use CTRL+E (for backward compatibility). F5
Help for SQL Query Analyzer. F1
Help for the selected Transact-SQL statement. SHIFT+F1
Navigation: Switch between query and result panes. F6
Navigation: Switch panes. Shift+F6
Navigation: Window Selector. CTRL+W
New Query window. CTRL+N
Object Browser (show/hide). F8
Object Search. F4
Parse the query and check syntax. CTRL+F5
Print. CTRL+P
Results: Display results in grid format. CTRL+D
Results: Display results in text format. CTRL+T
Results: Move the splitter. CTRL+B
Results: Save results to file. CTRL+SHIFT+F
Results: Show Results pane (toggle). CTRL+R
Save. CTRL+S
Templates: Insert a template. CTRL+SHIFT+INSERT
Templates: Replace template parameters. CTRL+SHIFT+M
Tuning: Display estimated execution plan. CTRL+L
Tuning: Display execution plan (toggle ON/OFF). CTRL+K
Tuning: Index Tuning Wizard. CTRL+I
Tuning: Show client statistics CTRL+SHIFT+S
Tuning: Show server trace. CTRL+SHIFT+T
Use database. CTRL+U

Why is Alt + X (Execute Query) not listed over here in the shortcuts ??